If A1 has the cell you want to change color and it contains the date the
last time you were in an area, try the following:

FORMAT/CONDITIONAL FORMATING

In Condition 1 choose FORMULA IS from the dropdown
In the formula area type =NOW()-A190

Then hit condition and format as you wish (change background, text
color, etc)

Do the same and change 90 to what ever length you want to check for.

This will subtract A1 from today's date, and if 90, it will format as
you set.

Happy & Safe fishing.

John


--
JohnGuts
------------------------------------------------------------------------
JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174
View this thread: http://www.excelforum.com/showthread...hreadid=535275