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.
You are here