12 conditional formats

[AmberJo]

I know it is possible to do 3 conditional formats (or 4- using anything that doesn't fit the 3 conditions as a 4th condition)- but I need to do 12 (or 11- depending on how you look at it). Is this possible? And yes, it is necessary. I have 12 stages that a document can be at (eg first edit, first process, first review, second edit etc all the way through to online).

Any help would be greatly appreciated.

Thanks,

Amber-Jo

 

[straus]

it would be very beneficial to all the readers of Mr Excel, to know how the problem is sorted out. If the Code could be pasted in here, that would be the ultimate. thanks