» Conditional Formatting in Excel 2007

To use Conditional Formatting ready to use rules:

Select Home -> Conditional Formatting (in Styles Group) -> Highlight Cells Rules or Top/Bottom Rules.

To set a new rule:

Select Home -> Conditional Formatting (in Styles Group) -> New Rule.

To clear Rules:

Select Home -> Conditional Formatting (in Styles Group) ->Clear Rules -> Selected Cells or Entire Sheet.

To manage rules:

Select Home -> Conditional Formatting (in Styles Group) -> Manage Rules.