CONDITIONAL FORMATTING

[robzrob]

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?

 

[Tim879]

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.

 

[Bob Phillips]

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.

 

[robzrob]

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






- Show quoted text -

Thanks, Tim & Bob