Dynamic Conditional Formatting
Charts and Visualization

Dynamic Conditional Formatting in Excel

In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights according to the selection of Option button. While selecting the Heat Map option button- [caption id="attachment_19032" align="aligncenter" width="776"] Heat Map Conditional Formatting[/caption] While selecting the Data Bar option button- [caption id="attachment_19033" align="aligncenter" width="774"] Data Bar Conditional Formatting[/caption] While selecting the
Advanced Condtional Formatting
Excel Tips and Tricks

Search Text from Specific or all columns in Excel

In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two type of search –Search in specific column and Search in all columns. Note: This trick is useful only for small data set. Search in specific Column: To search in specific column, just select the column name form the drop down
Birthday Count
Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how to highlight the data using Conditional Formatting whose birthdays are in This Month, Last Month and Next Month. We have below given Date of Birth data for Employees- [caption id="attachment_14951" align="aligncenter" width="435"] Date of Birth data[/caption] We have created a
Highlight Unmatched Cells
Excel Tips and Tricks

Highlight Unmatched Cells using Conditional Formatting in Excel

In this article you will learn how to highlight the Unmatched Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the Sales worksheet we need to highlight the Products which are not available in Product Master. [caption id="attachment_12307" align="aligncenter" width="1496"] Sales Data and Product Master Worksheets[/caption] Below are the steps to put the Conditional Formatting to highlight Product Name in Sales
Highlight Consecutive Duplicates
Excel Tips and Tricks

Highlight the Consecutive Duplicates in Excel using Conditional Formatting

In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance Sheet. Let’s say we have month wise sales wherein we have month name duplicate. We want to highlight the consecutive duplicate month as given in below image [caption id="attachment_12290" align="aligncenter" width="282"] Consecutive duplicate month[/caption] Below are the steps to put
Highlight Top and Bottom Performer
Excel Tips and Tricks

Highlight Top and Bottom Performer using conditional formatting

In this article you will learn how to use Conditional Formatting to highlight the Top/bottom performer on the base of performance score. Top performer has been highlighted in green color and Bottom performer has been highlighted in red color. A drop-down of Top Performer and Bottom performer has been given on cell C1 using Data Validation list. In the below image, top performer has been highlighted. To highlight the top