Conditional formatting with more than 3 conditions.
 

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