Conditional Formatting

B

BDavis

I need to condionally format a field so that if the field
= 1 it's yellow, if it = 2, it's Blue, etc...

The conditional format feture only allows you 3 conditions
and I need six. How can I get around this... I'm assuming
I'll have employ code.

Thanks.
 
Top