I work with cases that can each be at a different status. Some statuses
can be considered cleared. These are the ones i am highlighting. I also
need to highlight them when a set date passes to prompt action to be
taken.

The reminder at workbook/ exel startup is to remind them to archive the
cleared cases.

This formatting will make working these cases a lot easier.


Harald Staff wrote:
How many conditions do you need ? Don't expect your users to immediately
understand what your 8 different colors/color combinations are trying to
tell them. Some things make sense on the drawing board only.

HTH. Best wishes Harald


skrev i melding
oups.com...
Thanks folks but i need to highlight more than 3 conditions so it's
gonna have to be code.