Constant

This looks at the actual value in a cell. This is not necessarily the value that is displayed.
In the first drop-down box select "Cell Value is".
In the second drop-down box you can choose from a selection of different operators.

alt text

The remaining boxes are for your values. These can either be entered directly as constants or they can be cell references.


Using a Constant

We are going to apply conditional formatting to the range of cells "B2:E5" and we are going to shade all the cells which contain a number greater than 10.
Select the range of cells you want to apply the conditional formatting to, in this case cells "B2:E5".

alt text

Select (Format > Conditional Formatting) to display the Conditional Formatting dialog box.
Select "Cell Value Is" in the first drop-down box and "greater than" in the second dialog box.
Enter the constant value 10 in the third box.
Click the Format button to apply your specific formatting, in this case we are just applying a grey background.
This is actually the (Format > Cells) dialog box but it only contains the Font, Border and Patterns tabs.

alt text

Press OK to apply your conditional formatting.

alt text

Important

If you choose "between" or "not between" then you have the choice to enter both a lower and upper limit.


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext