Dynamic Conditional Formatting in Excel with Option Buttons
Dynamic conditional formatting in Excel lets one table switch between a heat map, data bars and traffic-light icons with a single click. In this tutorial you build it with four
Tag: Formula in conditional formatting
Search Text from Specific or All Columns in Excel (No VBA)
Want to search text from specific or all columns in Excel and see the matching rows instantly, without filters or VBA? In this tutorial you will build a small search
Highlight and Count Birthdays from Date of Birth in Excel
Want to count birthdays from date of birth in Excel and highlight who is celebrating this month? In this tutorial you build a small birthday tracker from a plain employee
Highlight Unmatched Cells in Excel with Conditional Formatting
To highlight unmatched cells in Excel, you compare each value with a second list and colour the ones that are missing from it. A typical case: your sales sheet contains
Highlight Consecutive Duplicates in Excel with a Simple Formula
To highlight consecutive duplicates in Excel, you only need one conditional formatting rule with a short OR formula. It colours a value only when the same value sits directly above
Highlight Top and Bottom Performer using Conditional Formatting
You can highlight the top and bottom performer using conditional formatting in Excel so the best and the weakest employee light up the moment you pick an option from a