Conditional Formatting Formula Range Number of Conditions

[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.

 

[Andy Brown]

=AND($D$10>2,$D$10<8)

Rgds,
Andy

 

[Jon]

Works great -- thank you Andy.

Jon