Remove Duplicates in Excel: Tools and Formulas

Discover three easy ways to remove duplicate values in Excel. Our guide provides simple tools and formulas to streamline your data.

Master Conditional Formatting in Excel

Discover how to master conditional formatting in Excel. Learn its benefits, types, and tips for accurate data analysis.

Icons with Conditional Formatting in Excel

Learn how to use icon conditional formatting in Excel to visualize your data and create dynamic dashboards.

Progress Bar in Excel with Conditional Formatting

Discover how to create and customize progress bars in Excel using Conditional Formatting. Track progress with ease.

Color Row Conditional Formatting in Excel 🎨

Learn how to apply Color Row Conditional Formatting in Excel to highlight rows that meet specific criteria.

How to have 2 different highlight colors in Excel?

Learn how to highlight 2 different colors for 2 distinct values in Excel using conditional formatting with this guide.

How to Highlight Min and Max values in Excel

How to highlight the min and the max with a specific color in Excel? This step-by-step guide will explain the technique.

In Excel, How to highlight missing values?

Become an Excel master with this handy Excel trick to highlight missing values using conditional formatting and no formula.

Conditional Formatting – Color scale

A color scale is an option for the conditional formatting of Excel. It's a useful way to present the similarity of your data.

Highlight the Date outside the deadline in Excel

How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.

Copy a Conditional formatting rule

You can now copy a conditional formatting rule with Excel 365. This option has been added for Excel 365 only.

Change the Color of Weekends in Excel 🗓️🎨

Change the color of weekends in Excel with conditional formatting. Quick and easy with this step-by-step guide.

How to Highlight a Birthday Reminder in Excel

This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs

Find Weekend or Weekday in Excel

Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.

Change the color of holidays

You can change automatically the color of the public holidays in your calendar with the conditional formating and a custom rule.

Highlight Top / Bottom values with the conditional formatting

You can easily highlight the highest or lowest values of your document with the conditional formatting. Easy to use and to manage

Create a progress bar with icons

Learn how to create a progress bar with icons in your worksheet using simple steps. Crop and align icons for a professional look.

How to make automatic calendar in Excel

This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.