Need help with formula for conditional format

Closed
Report
-
 Excelnoob -
Hello,
if date in cell is less than 2 weeks of the current date highlight it green

2 replies

Not sure if you got this one yet.

Assume the cell you want formatted is A1.
Open the conditional formatting option "format" => "Conditional Formatting"
Condition 1 should look like this:
Cell Value is
Less than
then type the following:
=today()-14

Then just choose the formatting you want the cell to have and voila. Anything with a date older than 2 weeks is hilighted.
8
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

That was really helpful, thank you.

Try this in your Conditional formatting formula where I8 in this formula is the cell your formatting and is also where the date being tested is located.

=I8<TODAY()+14