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