Cond. Form. Question

  • Thread starter Thread starter Roger Fuherdenhaden
  • Start date Start date
R

Roger Fuherdenhaden

How do I make a text cell(A1) change color if it is between zero to 14 days from the current date(A2)?

But I also need it to drop the color after the date passes and go back to transparent.

Thanks.
 
In a cell, enter =today(). Let's say this is cell b1
Select your date.
Format>Conditional format

Use Between $b$1 and $b$1+14 and select format Red

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


Roger Fuherdenhaden said:
How do I make a text cell(A1) change color if it is between zero to 14
Click to expand...
days from the current date(A2)?
 
Back
Top