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


On Jan 25, 12:56 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Conditional formatting
--
David Biddulph

"petergw" wrote in message

...

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