Hi Kim,

if you have only 4 criteria, use simple formating for all fields you want to
format conditionally. Then add typical conditional formating (only for three
criteria). The fourth option will remain with original format.



"Kim Shelton at PDC" wrote:

I have 4 criteria for conditional formatting as follows: I have 4 work crews.
1=green, 2=blue, 3=tan, 4=yellow. If I type a 4 in the cell I want the fill
color to become yellow etc. I obviously can only do three - How can I do 4.
Thanks.