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?