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
Tag: Conditional Formatting
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
Stylish Traffic Lights in Excel: Shapes + Conditional Formatting
Stylish traffic lights in Excel give your dashboard a glossy, 3-D status lamp for every KPI that turns red, amber or green on its own. The trick is simple: a
Arrow Symbols in Excel with Custom Formatting and Data Bars
Arrow symbols in Excel with custom formatting let you show a coloured up or down arrow right next to a percentage, without a single extra formula or helper column. In
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
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
Checkbox in Excel Table: Highlight Rows and Sum Checked Items
A checkbox in an Excel table is one of the quickest ways to let users pick rows. In this Excel tip you put one Form Control check box in every
Quality Check List in Excel with Pass/Fail Icons (Free Template)
This quality check list in Excel lets your quality team mark every product as Pass or Fail from a drop-down, and Excel turns each choice into a green tick or
Conditional Formatting in a Lollipop Chart in Excel (4 Variants)
Adding conditional formatting in a lollipop chart in Excel lets your audience see at a glance which days hit the sales target and which did not: every value above the