View Single Post
  #2   Report Post  
nbrcrunch
 
Posts: n/a
Default


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!


--
nbrcrunch