Topic 12 – Notes

APPLY BASIC CONDITIONAL FORMATTING

 

After completing this lesson, you should know:

  • What Conditional Formatting is
  • How to format cells based on a basic rule
  • How to clear Conditional Formatting

Conditional Formatting lets you change the appearance of a cell based on its value or another cell's value. You specify certain conditions, and when those conditions are met, Excel applies the formatting that you choose.




Format Values Based on a Rule

We need to see the Leave Days (column G in our example) less than 5 in a specific colour.

Method:

  • Select the values in column G (G2 to G20 in our example)
  • Home ribbon tab → Styles group → Conditional Formatting
  • Highlight Cells Rules → Less Than…
  • Type 5
  • Choose colour
  • OK











The result:












Format Text Based on a Rule

We need to see all the email addresses (column D in our example) with the word “gov” in a specific colour.

Method:

  • Select the email addresses in column D (D2 to D20 in our example)
  • Home ribbon tab → Styles group → Conditional Formatting
  • Highlight Cells Rules → Text That Contains…
  • Type gov
  • Choose colour
  • OK











The result:

 












Clear Formatting

Select the cells with the formatting → Click on Conditional Formatting → Clear Rules (choose between selected cells and entire sheet)




















Exit
Laaste wysiging: Friday, 30 April 2021, 3:21 PM