Ike
01-28-2015, 01:43 PM
Hi everyone,
I am looking for a macro that when the below conditions are true, then color the cell in column I light green (Standard colors).
1. If a cell in column U has a date that is older than seven days. (Ignore blank cells)
2. And if there is not a number/text in column M (Ignore when cells have a number/text)
Then color the cell in column I light green (Standard colors).
This can be either, a stand alone macro or I can add it to an existing macro.
I would rather not use conditional formatting as there are already several on the tab. Since rows are deleted and added regularly, I find it necessary to
update the formulas often when using conditional formatting.
Thank you in advance.
Ike
I am looking for a macro that when the below conditions are true, then color the cell in column I light green (Standard colors).
1. If a cell in column U has a date that is older than seven days. (Ignore blank cells)
2. And if there is not a number/text in column M (Ignore when cells have a number/text)
Then color the cell in column I light green (Standard colors).
This can be either, a stand alone macro or I can add it to an existing macro.
I would rather not use conditional formatting as there are already several on the tab. Since rows are deleted and added regularly, I find it necessary to
update the formulas often when using conditional formatting.
Thank you in advance.
Ike