CONDITIONAL FORMATTING

  • Thread starter Thread starter robzrob
  • Start date Start date
R

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?
 
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.
 
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.
 
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 -
Click to expand...

Thanks, Tim & Bob
 
Back
Top