Creating a cell value condition

To create a cell value condition:

  1. Right-click the cell in which to create the condition and select Conditional Formatting. Then select Cell value is in the Condition field.
  2. Select an operator.
    For example, Between, Equal to, etc.
  3. Specify a value or range of values, depending on the operator you have selected.
  4. Click Add.
    The condition is added to the List of conditions.
  5. Click the condition.
  6. To assign a predefined format to the condition, select a format from the list.
  7. To specify a format for the condition, select Format in the list and click the Edit Entry Format icon.
    The Edit Format dialog is displayed.
  8. Specify the format to apply.
    The Edit Format dialog operates in the same way as the Format Cells dialog.