Microsoft Excel- Conditional Formatting

Mastering Data Visualization Techniques in Excel

Created by: Rajesh v
Instructor at Udemy

What Will I Learn?

• Basics of Conditional formatting
• Kinds of conditional formatting
• Custom conditional formatting with formulas
• How to highlight lines that are "too long" with conditional formatting - a great example of how to use CF for quality control.
• How to build a search box with conditional formatting.
• How to calculate and highlight expiration dates - quickly highlight dates that are within 60 days, 30 days, or any time frame you need
• How to do zebra striping with conditional formatting

Requirements

• Having Excel installed, any excel version will do

Target audience

• People who want to learn Excel Conditional Formatting
• Advanced users who might need to do a review and go back to the basics on excel conditional formatting
• Beginners to Intermediate Users who want to develop their excel skills
• Controllers that work with excel, power bi python and so on that will find conditional formatting very useful for developing their controls and alerts to the next level
• Working Professionals in general as excel is needed in most professions (Accountants, Controllers, Engineers, Architects, Analysts, Managers, Human Resources Managers, Teachers, Professors etc.)