Conditional Formatting with If/then

[marisa.a.k]

Morning All,

I have a spreadsheet that manages the due dates of action items. I use a three color system: yellow = pending, green = complete, and red = overdue. I want these cells to do the following:

If past a certain date turn red and stay red until I manually turn it green.

But if I have turned the cell green prior to the due date, I do not want the cell to turn red.

Any help would be great!

[ChemistB]

Unfortunately, Excel's formulas cannot tell if your background color is green. I do not believe this is possible with conditional formatting. You'd need to do something else to clue Excel in, like putting an x in column Z.

[arlu1201]

Marisa,

You do not have to start another thread in the programming section if you want a macro solution. You can just report your post to the moderators by clicking on the triangle below it asking it to be moved to the programming forum.

I have closed this thread. You can resume in your other thread.