make a cell red after 14 days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
format|Conditional Formatting| formula is : =TODAY()-14 >= a1
{format to red}
A1 is the cell your entering the date
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Dates and CF Colour then convert to Text 3
Excel High lightng dates in future, today and past 1
Red cell for negative numbers in Excel 1
A staying on schedule formula: 2
Add data every 14 days? 1
Using Three Conditions in CF 3
Can I have a cell change to red/green if not equal to: 7
Date Conditional Formatting 4

Back
Top