I have a log where I track all applications. For a given month I need to
easily identify cases that I need to complete prior to the last day of the
month. I have a progression tracker that if is one of four different numbers
would indicate I need to take a final action on the case prior to the end of
the month or the item would be overdue, the four items would have the case
completed date as a null value because they are not completed and I want the
items to show as RED for the back ground when the day in the system is equal
to or after the 19th of the month so that I know I have to complete those
cases before I do anything else.

In progression the criteria would be either 3,4,5 or 15 and in I/R indicator
would be 2 and date completed is null.

Do I code using conditional formatting or Should I add this to the current
VBE code that I have that right now changes the format and coloring of a case
when the progression indicator is updated?

Looking for the easiest way out on this one.

Thank you.

[venkat1926]

if your version of excel is 2003 or before you can have only three conditional formatting. It is better to have a macro for this.