Excel - Conditional formatting

 Excel - Conditional formatting

 

 Conditional formatting in Excel is a feature that allows you to automatically format cells based on specific conditions or rules you define. It helps you visually highlight and emphasize data that meets certain criteria.

1. **Value-Based Conditional Formatting: **

   Format cells based on their numeric values, like highlighting cells that are above a certain threshold.

 

2. **Text-Based Conditional Formatting: **

   Format cells based on the text they contain, such as highlighting cells with specific words or phrases.

Conditional formatting in Excel offers various types of rules to format cells based on different conditions. Some common types of conditional formatting rules include:

 

Here are the steps to apply conditional formatting:

1.     Choose a rule type, such as "Highlight Cells Rules" or "Top/Bottom Rules."

2.     Define the condition or criteria for formatting, like values greater than a certain number.

3.     Configure the formatting options, like text colour, fill color, or font style.

4.     Click "OK" to apply the conditional formatting to the selected cells.

 

 

1. **Highlight Cells Rules: **

   - Greater Than

   - Less Than

   - Between

   - Equal To

   - Text that Contains

   - A Date Occurring

   - Duplicate Values

 

2. **Top/Bottom Rules: **

   - Top 10 Items

   - Bottom 10 Items

   - Above Average

   - Below Average

 

3. **Data Bars: ** Create horizontal bars in cells based on values.

 

4. **Color Scales: ** Apply color gradients to cells based on value ranges.

 

5. **Icon Sets: ** Use icons to represent data ranges (e.g., arrows for values above/below average).

 

6. **Custom Formula Rules: ** Define your own formatting rules using Excel formulas.

 

7. **Highlight Cells with Rules: **

   - Duplicate Values

   - Unique Values

   - Specific Text

   - Blanks

 

8. **New Rule: ** Create a custom rule with specific formatting and criteria.