View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Conditional Formatting

see your other post.

regards
FSt1

"Mya48" wrote:

I have a calendar that I would like to do the following using conditional
formatting:
If a cell = d, I would like for it to display the text D/O in white font and
purple fill. I've got the white font and purple fill working but I can't get
it to display the text D/O. Any ideas?

Right now it's set up like this:
=IF(C4="d",1, 0)

Thanks.