4 condition conditional formatting

[jeffg]

Pls. if any one has any info..
I ve worked out and cleaned up a macro to automatically import external data
from multiple sources,lookup and match table values, and generate and Pivot
Report for product process locations, and current product test equipment
configurations.
What I need to do now is to use a color coding system to assign equipment
setup priorities based on nearest product location.
Color Bars would stretch across an entire row on the pivot report.

I can easily accomplish this for the most part with conditional formatting
but with only 3 levels of priority.

Any ideas on how I can get the fourth worked out, and have it fill an entire
row or range?

Thxs
-Jeff

 

[Bob Phillips]

Jeff,

If you set all the data one colour, and then use CF for three of the
conditions, you effectively get 4 colours.

As you only need four, this should work for you.

Regards

Bob

 

[jeffg]

Thx Bob
It's called Tunnel Vision - Sometimes the most obvious things are the
hardest to get to.
-Jeff