Conditional Formatting

M

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
display '2+2' as '4' in a cell? 5
Columns appearing from nowhere, formatting going weird 0
Countdown macro - display settings 2
Document Merge Formatting Issue 0
Conditional Formatting 0
Conditional Formatting using variable text 4
Conditional formatting disappears when cell contents deleted 2

Top