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.

Conditional Formatting – Highlight highest values

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.

Highlight Weekends in Excel

In Excel, you can change the color of the weekend in your workbook by creating your custom rule in the conditional formatting tool.

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

Displaying Negative Numbers in Parentheses – Excel

If you want to turn your negative numbers with parentheses, you have to create a custom number format. Read how to do this here.

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.

Dash for a zero in Excel

How to display a dash ( - ) instead of a zero in Excel? Follow this step-by-step guide to learn how to customize your numbers.

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 according to the value in Excel

How to change the color of your cells according to the values? With the conditional formatting tool of Excel, it's very easy

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

How to color the entire row with the conditional formatting. Discover the technique, step by step in this article.

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.