Master Class on Conditional Formatting 

Course Fee - INR 500

Why it's important!

Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data.A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted. There are many built-in conditions, and you can also create your own.

COURSE CURRICULUM

Master Class on Conditional Formatting
  • Master Class on Conditional Formatting
Downloadable Working Files
  • Downloadable Working Files

Salient Features of the Course 


👉 What is Conditional formatting

👉 Formatting for Duplicate/Unique Values

👉 Top/Bottom Solution

👉 Data Bars/Color Scales/ICON Sets 

👉 How to clear rules

👉 Custom Conditional Formatting Rules

👉 Timesheet with conditional formatting

👉 Formula-Based Conditional Formatting

👉 How to use ISTEXT, ISBLANK, ISNUMBER and ISFORMULA as conditions

👉 Some interesting Business Cases

  1. Alternating row color with conditional formatting 
  2. Fun Example of saying Thank you with Conditional Formatting     
  3. Use Conditional Formatting to highlight Row and Column     
  4. Dynamic conditional formatting based on previous values higher or lower

👉  Q&A


CONNECT WITH US