Query, Share and Manage Excel workbooks on LAN, Internet

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.