exel 2007 process

[petergw]

hi,
i have a a spreadsheet showing refresh dates for training. How do I enable
it to change colour at date minus 30 and date minus 60 days to highlight
training needs?

Peter

 

[David Biddulph]

Conditional formatting

 

[Matt Richardson]

For more details on how conditional formatting works, try this link
which explains most aspects in an easy to read format:-

http://www.cpearson.com/excel/cformatting.htm