View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Conditional formating

see response to your other posting

--
Regards
Roger Govier



wrote in message
oups.com...
I have a spreadsheet with multipe dates I want to have dates less than
01/11/2007 in the cell to turn into R with Red background and for
dates more than 01/11/2007 to turn into X with Green background and
all blank cells to be blank. I can do some of it with 2007excel
however I can not get the blank cells to remain blank and how can this
be done in excel 2003