In which order does Excel look at conditional formatting? I've been
assuming Condition 1, then 2, then 3. What if one condition
contradicts another (for some values)? What then?

Excel looks at each condition in order (i.e. condition 1 then 2 then
3)

Once it finds a true value at a selected condition, it stops
processing and formats the cell accordingly.

It doesn't matter if the formats contradict one another since they
will always process sequentially.

On Jun 16, 10:04 am, robzrob wrote:
In which order does Excel look at conditional formatting? I've been
assuming Condition 1, then 2, then 3. What if one condition
contradicts another (for some values)? What then?

It looks at 1, 2 then 3. It is very important to get the logic correct. For
instance if you have two tests for 20 and 100, if you put the 20 test
first, it will never do the 100 test, as it will pass the 20 test and
exit.

--
__________________________________
HTH

Bob

"robzrob" wrote in message
...
In which order does Excel look at conditional formatting? I've been
assuming Condition 1, then 2, then 3. What if one condition
contradicts another (for some values)? What then?

On Jun 16, 3:12*pm, "Bob Phillips" wrote:
It looks at 1, 2 then 3. It is very important to get the logic correct. For
instance if you have two tests for 20 and 100, if you put the 20 test
first, it will never do the 100 test, as it will pass the 20 test and
exit.

--
__________________________________
HTH

Bob

"robzrob" wrote in message

...



In which order does Excel look at conditional formatting? *I've been
assuming Condition 1, then 2, then 3. *What if one condition
contradicts another (for some values)? *What then?- Hide quoted text -

- Show quoted text -

Thanks, Tim & Bob