making a cell change colour after a specified period of elapsed time

M

Mighty Magpie

Hi,

I am using Excel 2002 and would like to be able to set up a file I have so
that when a certain number of days has elapsed (28) a specified cell changes
colour - to alert me visually that some data needs to be updated

I have
Cell B1 contains the date that I have entered the data (date entered
manually)
Cell C1 contains the date when the data will need to be renewed (I have
simply entered =B1+28 but there is probally a much cleverer way)

I would like Cell D1 to change colour after 28 days

Can someone please advise me?

Cheers,

TIA
 
I

IC

In conditional formatting for D1 select "Formula is" and enter

=TODAY()-$B$1>=28

Configure the format you require. If you need to copy the formula down
column D, corresponding to the same row in column B, then remove the
$between B & 1.

Ian
 
J

Jason Morin

Your question is not very clear. I'm guessing here, but
it seems you want C1 to change color when today's date is
28 days from the date in A1. Or, in other words, when
today's date equals or is greater than the date in B1. In
that case, select D1, go to Format > Conditional
Formatting, Formula Is, and put:

=B1+28<=TODAY()

Click the format radio button and format as desired.

HTH
Jason
Atlanta, GA
 
M

Mighty Magpie

Many thanks to both who replied with suggestions and advice - they work a
treat

Cheers
 
Top