exel 2007 process
 

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

exel 2007 process
 

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

exel 2007 process
 

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