make a cell red after 14 days
 

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

make a cell red after 14 days
 

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

"ade" wrote:

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

make a cell red after 14 days
 

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



"ade" wrote in message
...
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