View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiveUser LiveUser is offline
external usenet poster
 
Posts: 90
Default If, Then Color Cell

If the date in cell C3 is after date in cell C1, then color cell orange.

If this is possible then can I do this:

If the date in cell C3 is after the date in cell C1, then color cell orange
and If the date in cell C3 is before the date in cell C1, then color the cell
light blue.

Thank you.