Excel bug: conditional formatting

  • Thread starter Thread starter Shawn Casey
  • Start date Start date
S

Shawn Casey

When using conditional formatting with more than more
formula, the formatting ceases to go through all
conditions once one condition becomes true.

This isn't the same behavior as when cell values are used.

This to me is a bug, but if this is intended, it should
at least be an option to continue through all conditions.
 
The behaviour is the same when cell values are used. For example:

Condition 1: Cell Value Is greater than 10 Format: Bold
Condition 2: Cell Value Is greater than 20 Format: Red
Condition 3: Cell Value Is greater than 30 Format: Italic

A cell that contains a 12 will be bold, as will a 25 and a 40.

However, if I put the most difficult test first, and the least difficult
test last, the cells will be formatted differently.
Condition 1: Cell Value Is greater than 30 Format: Italic
Condition 2: Cell Value Is greater than 20 Format: Red
Condition 3: Cell Value Is greater than 10 Format: Bold

If you want a cell to meet multiple criteria, you can use a formula,
such as =AND($A1="Paid",$B1>=TODAY()-7)
 
Shawn
from the Excel help file :
Note Using multiple conditions If more than one specified condition
is true, Microsoft Excel applies only the formats of the first true
condition, even if more than one condition is true.


So the program is performing as designed, see Debra's note about
changing the order of the conditions.

Mike
 
Back
Top