Need help with formula for conditional format

Nohill - Mar 28, 2009 at 11:37 AM
 Excelnoob - Dec 6, 2009 at 08:44 PM
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:

Then just choose the formatting you want the cell to have and voila. Anything with a date older than 2 weeks is hilighted.
That was really helpful, thank you.
excel challenged
Apr 1, 2009 at 12:07 PM
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.