Conditional Formatting Formula Range Number of Conditions

  • Thread starter Thread starter Jon Cameron
  • Start date Start date
J

Jon Cameron

I need to somehow exceed Excel's limit of 3 conditions to
format a cell. One possibility would be to specify that
a cell is equal to a range.

For instance, I can already specify: =$D$10>2;

but I would like to say: =$D$10>2<8

Essentially cell D10 is greater than 2, but less than 8.

However, I can not get a range formula to work. Anyone
know how to enter a range in conditional formating? Or
any other hints on more than 3 conditions.

Thank you for any help.
 
Back
Top