Conditional Formatting

[Mya48]

How would I go about making a cell change the text to equal D/O if the cell
is equal to "d". I can use conditional formatting to make the text white and
the fill purple but I can't get the formula to change the text from "d" to
D/O. Any ideas?

I currently have this furmula under the conditional formatting:

=IF(C4="d",1, 0)

Thanks

 

[FSt1]

hi
conditional formating cannot change the data in the cell, only the formating.
an if formula in the call can to that but not CF. if a formula wont work for
you then you may be looking at an event macro.

Regards
FSt1