make a cell red after 14 days

A

ade

hi i want to enter a date in a cell and when 14 days have passed i would like
that cell to turn red. is this possible??

thanks ade
 
L

LanceB

format|Conditional Formatting| formula is : =TODAY()-14 >= a1
{format to red}
A1 is the cell your entering the date
 
C

CLR

Left-click on the cell you wish to set up, then Format >
ConditionalFormatting > FormulaIs in the left window and =$A1+14<TODAY() in
the right widnow, then click FormatButton > PatternsTab > Select the red
color square > OK > OK

Vaya con Dios,
Chuck, CABGx3
 
Top