Conditional Formatting
 

Can anyone help!

Is it possible for a cell to change colour after a given period of time has
elapsed.

ie 30 days after the 01/02/06 or 60 days after the 20/02/06.

Regards
Humpy

Conditional Formatting
 

If those dates appear somewhere in the spreadsheet, then yes.

Assume 01/02/06 is in cell A1, and you want cell B1 to change color when 30
days have lapsed

Select B1, go to Format-Conditional Formatting.. and select Formula Is and
use the formula

=$A$1<(TODAY()-30)

then click on the format button, go to the patterns tab and choose the color
you want the cell to display. OK your way out & you're done


"Humpy" wrote:

Can anyone help!

Is it possible for a cell to change colour after a given period of time has
elapsed.

ie 30 days after the 01/02/06 or 60 days after the 20/02/06.

Regards
Humpy

Conditional Formatting
 

:) Excellent, Thanks a lot

Humpy!!


--
Humpy
------------------------------------------------------------------------
Humpy's Profile: http://www.excelforum.com/member.php...o&userid=31895
View this thread: http://www.excelforum.com/showthread...hreadid=516213