Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel LOOKUP Function
  • To count total rows in a range in Excel
  • Offset in Excel
  • How to get address of first cell in range in Excel
  • Two-column Lookup in Excel

Data Analysis Examples

  • How to Create Column Chart in Excel
  • Managing Conditional Formatting Rules in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Randomize/ Shuffle List in Excel
  • Excel Frequency Function Example

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation must not contain
  • Excel Data validation require unique number
  • How To Create Drop-down List in Excel
  • Excel Data validation no punctuation

Managing Conditional Formatting Rules in Excel

by

Manage Rules enables users click New Rule, Edit Rule and Delete Rule to create, edit and delete rules in Conditional Formatting in Excel.

To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager. You can also use this screen to create, edit and delete rules.

Worked Example:   Highlight every other row in Excel

1. Select cell A1.

2. On the Home tab, in the Styles group, click Conditional Formatting.

Worked Example:   Identify Duplicate Values vs Remove Duplicates in Excel

3. Click Manage Rules.

The Conditional Formatting Rules Manager appears.

Note: because we selected cell A1, Excel shows the rule applied to the range A1:A10.

4. From the drop-down list, change Current Selection to This Worksheet, to view all conditional formatting rules in this worksheet.

Worked Example:   Highlight dates in same month and year in Excel

Note: click New Rule, Edit Rule and Delete Rule to create, edit and delete rules.

Post navigation

Previous Post:

Identify Duplicate Values vs Remove Duplicates in Excel

Next Post:

Excel VLOOKUP and HLOOKUP functions Examples

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to check if cell contains number in Excel
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • Extract last name from full name — Manipulating NAMES in Excel
  • Add line break based on OS in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates ignoring years in Excel
  • Count birthdays by month in Excel
  • How to join date and text together in Excel
  • Custom weekday abbreviation in Excel
  • Get last day of month in Excel
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment periods for loan in Excel
  • IRR function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles