Conditional Formatting in MS Excel Tips and Tricks

MS Excel Tips & Tricks, MS Excel Blogs by Tafkeer, Data Validation in MS Excel

Conditional Formatting in MS Excel Tips and Tricks

Conditional Formatting in MS Excel

By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance
  • After selecting the data select one of the options to apply it to the selected cells.

A cascading menu will appear.

Data Bars: This is an interesting option that formats the selected cells with colored bars. The length of the data bar represents the value in the cell. The longer the bar, the higher the value.

Users must have knowledge of and competent in:

  • Basic Knowledge of MS Excel
  • Participants are required to bring their laptops with MS Office 2010/2013 installed in it.

Conditional Formatting & Sparklines

  • Formatting data on Conditions
  • Highlight Duplicate & Unique Values
  • Finding top 5 / 10 items in the Data
  • Formatting data using Data Bars & Icons
  • Clearing & Managing Rules
  • Nested loops
  • Analysing only total rows
  • Summerizing a data based on single attribute
  • Adding data based on two attributes

Summarizing & Consolidating

  • Creating Sub Totals
  • Sorting
  • Filtering
  • Extracting Unique Values with Filtering
  • Tips of copying Filtered data to New File

Icon sets:

Highlight duplicate records

Clear conditional formatting effect

You can also highlight Top 10 & Bottom 10 sales with conditional formatting

Explore our Excel Training Courses here and to read our blogs on MS Excel please click here.

Leave a Reply

Your email address will not be published. Required fields are marked *