Conditional Formatting
1. Select the cell/Range say Column A...
2. From menu FormatConditional Formatting
3. For Condition1Select 'Cell Value Is' ' 'Greater than' and enter 110
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK
If this post helps click Yes
---------------
Jacob Skaria
"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?
|