Conditional formatting

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 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.

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.

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 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.

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.

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

Create a progress bar with icons

Discover how you can create a progress bar in your Excel worksheet. All the steps explain in this article.

How to add progress bars in the cells?

You can display bars inside the cells to enhance the visualisation of the distribution or progress of your data. And you can customise your settings 😉

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.

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.

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.

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.