J
Judy Cohen
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.
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.