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
    • One For The Road
      • Secret Message With Conditional Formatting
      • Thank you!!!


Course Fee:
USD 39

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top