View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Josh is offline
external usenet poster
 
Posts: 103
Default Conditional formatting with expired dates after current

I am trying to get a cell to turn Red if the date that is in the cell is less
than or equal to the current date. The formula I have in it already is:
=EDATE(D2, 12)
This takes the date that I plug into the column before it and just adds 12
months to it. Thanks for any help you can offer.

V/R