Try this.

1. Select the range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Cell Value Is' and Select €˜Greater than from the
Ccondition drop down and in the next field type 110
4. Click Format ButtonPatternColor select 'red' then give ok

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"Mike McLellan" wrote:

How do I set the background colour of a cell to Red if the value of any cell
in a range is greater than, say, 110?