How go I get cells to change color if a date is greater than 365 .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brett - 11 Feb 2005 20:19 GMT

Here is what I am trying to do. I need to set up conditional formatting to
keep track of due dates. I enter a date in a cell, and I want the cell to
turn red if it is over a year over due based on "today's" date. Help!

Reply to this Message

nbrcrunch - 12 Feb 2005 03:07 GMT

Select the cell you want to apply the condition to.
In the conditional format box, select "formula is"

type:
=today()-[DueDateCell] GreaterThanSymbol 365

where "[DueDateCell] is the cell where the due date is entered.

(This board removes the greater-than-symbol, so replace
"GreaterThanSymbol" with the correct mark

Set the formatting

Your done!

Signature

nbrcrunch

Reply to this Message