View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JayM JayM is offline
external usenet poster
 
Posts: 12
Default conditional Formatting help

I have put some conditional formatting on columns in a spreadsheet as folows:

Cell Value is less than =TODAY() - format cell to Red
Cell Value is less than =TODAY()+30 - format cell to Orange
Cell Value is greater than =TODAY() - format cell to Green

But I now want to say if the cell is blank to leave it with no colour

Any help would be greatly appreciated.

JayM