Hello all,

I think I have an unusual problem. My problem is that I have more than 6
conditional format issues for one cell. Here is what I am up against.
I have 4 specification;
control points upper and lower limits (60-95%)
Primary control Sieve only lower limits (62%)
suspention limits Upper and lower limits (80 + 9 =
89% Max)

Action limits Upper and lower limits (80 +
6 = 74% Min)

Here is the issue:

I do gradations and we have specifications that need to be met on each
sieve. I must meet all the criterias that are above.
IE:

3/8" sieve Has 80% passing.

I am looking for 80% to plus (Suspention Limit) 9% or minus (Action Limit) 6%
I also must have at least 60% passing and not more than 05% passing (Control
Points)
I also need to have a minimum of 62% passing the 3/8" sieve (Primary Control
Sieve)

Now if any of these tolarances are not met I need it to highlight the cell.
If it is an action limit I need it to turn orange.
Any other limit needs to be RED
If there is nothing in the cell it needs to be white

I hope this makes sense. If not let me know.

Thank you all inadvance for your help. Just a thought, would this be better
as a macro?