You are here KNOWLEDGE Excel Tips Excel Text, Editing and Format Conditional Formatting in Excel 2007

Query, Share and Manage Excel workbooks on LAN, Internet

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.