Related:
- Need help with formula for conditional format
- Format factory - Download - Other
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Kingston format utility - Download - Storage
- Excel date format dd.mm.yyyy - Guide
2 responses
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.
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.
Dec 6, 2009 at 08:44 PM