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
Tag: Conditional Formatting
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
Stylish Traffic Lights in Excel
You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights in Excel.
Arrows Symbols (➷➹) with Custom Formatting in Excel
Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down Arrows
Highlight Unmatched Cells using Conditional Formatting in Excel
In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the
Highlight the Consecutive Duplicates in Excel
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
Employee Rating Table in Excel
An Employee Rating Table in Excel can be a powerful template to visualize and track employee performance across various parameters. So, instead of displaying simple numerical ratings, you can use
Excel Tip: Checkbox in Excel Table
Checkbox in Excel Form Controls is very useful in Microsoft Excel. Here we have created a table in each row one check box is available. We have used conditional formatting
Quality Check List in Excel
The template of Quality Check List in Excel has been designed to use for quality team. It can be use for other purposes also. Here we have taken the drop-down as
Conditional Formatting in a Lollipop Chart in Excel
Using the Conditional Formatting in a Lollipop Chart in Excel is very useful. It helps to audience to identify which category is meeting the target and which is not meeting.