MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Excel Conditional Formatting Master Class

### Course Summary

Learn how to use Conditional Formatting in Excel! Take your knowledge and skills to the next level.

• +

### Course Syllabus

• First Things First
• Welcome!
• Learning Tips
• Preset Conditional Formatting Rules In Excel
• Conditional Formatting Based On Text - Problem Definition
• Text-Based Conditional Formatting Rules - Solution
• Less Than, Greater Than, Equal To - Problem Definition
• Less Than, Greater Than, Equal To - Solution
• Date-Based Conditional Formatting (Date Occurring) - problem definition
• Conditional Formatting Based On Dates (Date Occurring) - Solution
• Highlight Duplicates - Problem Definition
• Highlight Duplicates - Solution
• Top-Bottom - Problem Definition
• Top-Bottom - Solution
• Data Bars, Icon Sets, Color Scales - Introduction
• Data Bars, Icon Sets, Color Scales - Solution
• Copy And Clear Rules
• Some Useful Points On The Default Conditional Formatting Rules
• Custom Conditional Formatting Rules In Excel
• Custom Conditional Formatting Rules - Overview Of Tools
• Icon Sets In Excel Based On Specific Numbers
• Displaying Icon Sets In Another Column
• Icon Sets Based On A Formula
• Icon Sets Triggered By Percents And Percentiles
• Custom Data-Bar Rules
• Formula-Based Conditional Formatting
• First Formula-Based Conditional Formatting Example - Problem Definition
• First Formula-Based Conditional Formatting Example - Solution
• Timesheet With Conditional Formatting - Problem Definition
• Timesheet - Solution
• Timesheet - One More Solution
• Conditional Formatting Based On VLOOKUP - Problem Definition
• VLOOKUP in Excel Conditional Formatting - Solution
• Alternating Row Color With Conditional Formatting
• Use Conditional Formatting To Highlight Row And Column - Problem Definition
• Highlight Row And Column - Solution
• Secret Message With Conditional Formatting
• Thank you!!!

Course Fee:
USD 39

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: