View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Johansen John Johansen is offline
external usenet poster
 
Posts: 3
Default conditional formatting

I am having trouble using conditional formatting when comparing two dates.
What I need is.

Cell A1 has a date 02/01/2007
Cell A2 has a date 03/05/2008

I want cell A2 Highlighted Red if the difference between the dates is 395
days or more.

I'm a novice in excel and any help is appreciated.

Thank you,
--
John Johansen