View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vicky vicky is offline
external usenet poster
 
Posts: 70
Default Conditional Formating

Hi,

I am currently trying to change the cells different colours when certain
dates are added and time frames are reached. So far i have got the cells
changing to green when a date is added and once the date is a year old it
turns to red using the below formula

=AND(ISNUMBER(H13),H13<=(TODAY()-365))

(where H13 is the cell the date is in)

Now i would like the cell to change orange 3months before the year is out
and red when the year is up, but i have been unable to do it thus far.

if anyone could help that would be much appreciated

thanks


vicky