Click on I9 and open the Conditional Formatting dialog (in Excel 2007
looking in the Styles group on the Hone tab; in earlier versions open the
Format dropdown on main menu).
First use the rule / Formula Is: =TODAY()-D929 and format for red
Then add a second rule ? Formula Is: =TODAY()-D920 and format for orange

See conditional formatting
http://www.contextures.com/xlCondFormat01.html

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"RichLive" wrote in message
...
Hello I would be very grateful if anyone could help pont me in the right
direction with a formula to do the following:
I have a date in field D9 and I need field I9 fill colour to change to
orange if today's date is greater than 20 days after the date in D9 and
then
turn red if today's date is greater than 28 days after the date in D9 I
hope
this makes sense, I am not to hot at excel at the moment but am trying to
learn

Many Thanks

Rich