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

[Brett]

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!

 

[nbrcrunch]

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!