What is Conditional Formatting?

How to Apply Conditional Formatting

1. Select the Range: Highlight the cells you want to format.
2. Access Conditional Formatting: Go to the Home tab on the Ribbon, and click on Conditional Formatting in the Styles group.
3. Choose a Rule Type: You can select from various options, such as:

• Highlight Cells Rules: Format cells based on their values (e.g., greater than, less than, equal to).
• Top/Bottom Rules: Highlight the top or bottom values in a range.
• Data Bars, Color Scales, and Icon Sets: Visualize data trends with graphical representations.
• Use a Formula: Create custom rules using formulas to determine which cells to format.

  3
• 3 Sources

  3

Example: Highlight Cells Greater Than a Value

1. Select the range of cells (e.g., A1:A10).
2. Click on Conditional Formatting > Highlight Cells Rules > Greater Than.
3. Enter the value (e.g., 80) and choose a formatting style (e.g., light red fill with dark red text).
4. Click OK to apply the formatting.

   1
5. 1 Source

   1

Using Formulas for Conditional Formatting

1. Select the range (e.g., A1:A10).
2. Click on Conditional Formatting > New Rule.
3. Choose Use a formula to determine which cells to format.
4. Enter the formula =ISODD(A1) and select a formatting style.
5. Click OK.

   1
6. 1 Source

   1

Clearing Conditional Formatting

1. Select the range of cells.
2. Go to Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.

   1
3. 1 Source

   1

Additional Tips

• Quick Analysis Tool: You can also use the Quick Analysis Tool that appears at the bottom-right corner of a selected range for faster access to conditional formatting options.

  1
• Highlight Duplicates: To identify duplicate values, select the range, go to Conditional Formatting > Highlight Cell Rules > Duplicate Values.

  1

  
  By utilizing these features, you can effectively analyze and visualize your data in Excel, making it easier to draw insights and make decisions. If you need more specific help or examples, feel free to ask!
• 2 Sources

  2