View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mya48 Mya48 is offline
external usenet poster
 
Posts: 3
Default Conditional Formatting

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.