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.

Alvin