View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BigH
 
Posts: n/a
Default Help with Conditional Formatting (Dates)

Hi there hopefully someone can help,

I want the cell to turn white if its the same date as two other cells or if
its less than the date in these two other cells, else it goes red if greater
than the dates in the two cells.

i.e cell a1 and a2 must have the same dates. cell a3 if it has the same date
or less than a1 and a2 it goes white, if its greater than a1 and a2 (whose
dates must be the same) then it goes red


thanks in advance BigH