Julie - I tried the formula and I can't get it to work. When I type in your
steps the entire column the background changes to Red ( Which I selected )
regardless of the date.My column is E5:E44

Thanks - George


"JulieD" wrote:

let us know how you go

"George" wrote in message
...
Thanks - will give it a try

"JulieD" wrote:

Hi George

to make it change colours you can use Conditional Formatting - select
your
dates - ensure that the first date is at the top (and visible) of your
worksheet
choose format /conditional formatting
choose formula is
type
=AND($A2=TODAY()-60,$A2<=TODAY())
where A2 is the first date in your range
click on Format
choose a formatting - background fill colours are under "pattern"
click OK twice

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"George" wrote in message
...
On my spread sheet I have a cell to indicate testing due dates - Is
there
a
way to make that cell flash or change colors 60 days prior to the
current
date ?