View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clyde
 
Posts: n/a
Default Results of conditional formatting not what desired. How do I corr

My formula produces a dd-mmm-yyyy result which is correct.

Cell L55 formula results a 17-May-2006

Conditional formatting is set to: Formula is: =L55<=TODAY()

With background pattern set to red.

My problem is that the conditional formatting doesnt produce the results I
desire which is that if the date in L55 falls within the month and year that
the background will be red.

How do I get the conditional formatting to do this?