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.

Add progress bar in your Excel cells.

How to display progress bars in your Excel cells according to the value in each cell? It's very easy with conditional formatting.

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.

Color an entire row with conditional formatting in Excel

Learn in a few steps, how to apply conditional formatting in Excel to color an entire row based on a specific condition.

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.

In Excel, How to Add Icons in your cells?

Excel allows you to add icons in your cells to show the trend of your data. Nothing is complex with the conditional formatting tool.

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 Compare 2 Columns in Excel

Learn how to compare two columns in Excel efficiently using simple techniques. Easy-to-follow guide with clear explanations and examples.

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

What is conditional formatting in Excel?

Unlock the power of conditional formatting in Excel and effortlessly highlight, analyze, and visualize data with dynamic formatting rules.

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.