Tag Archive: Conditional formatting

Articles sur le thème : Conditional formatting

What is a conditional formatting

Change the color automatically

In Excel, you can change automatically the colors of your cells with the conditional formatting. And you have a lot of options (icons, bars, …)

Permanent link to this article: https://www.excel-exercise.com/what-is-a-conditional-formatting/

Conditional Formatting – Highlight highest values

It’s quite easy with the conditional formatting tool to highlight the highest and lowest values of your data. Highest / Lowest value Select the range of cells where you have your data Select the menu Conditionnal Formating > Top/Bottom rules > Top 10 items In the dialog box, replace 10 by 1 and choose a …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/top-bottom/

Conditional Formatting – Color scales

This article will present you the option Color Scales in the Conditional Formatting of Excel. What is a color scales? A color scales is the way to present your data with a slight difference of color in function of the values. Use the color scales option makes sense only if you have a range of …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/color-scales/

Conditional Formatting – Data Bars and Icons

The conditional formatting allows you to add Data Bars and the icons in your cells is function of the result of rules. The Data bars When you insert a conditional formatting Data Bar, everybody will approve your document. It’s an instant success. 👍😎😊 The method to insert Data Bar in your cells is very simple. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/data-bars-and-icons/

Conditional Formatting – Highlighting dates

With Date functions in Excel, it is possible to perform calculations like addition or subtraction and thus, produce automated or semi-automated worksheets (using the NOW function in particular). Date functions mix with conditional formatting, allow you to create spraedsheets displaying date alerts automatically when a deadline is near. Basics of Conditional formatting with dates In the menu Home …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/highlighting-dates/

How to make automatic calendar in Excel

Automatic calendar finished

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

Permanent link to this article: https://www.excel-exercise.com/how-to-make-automatic-calendar-in-excel/

Weekends or weekdays in Excel

Separating weekends and weekdays is a basic job in Excel. For example, when you have to build an automatic calendar.  The function WEEKDAY Presentation This function returns a value between 1 and 7 corresponding to the value of the day of the week. =WEEKDAY(Date,Parameter) This function is very, very, VERY useful for creating a test …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/weekends-weekdays-excel/

Compare 2 Columns

Missing value are in red automatically

You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values

Permanent link to this article: https://www.excel-exercise.com/compare-2-columns/

How to Highlight a Birthday Automatically

Gap in days and months before after the birthday

In this article, you will see how you can change color when a Birthday is coming up without using a macro.

Permanent link to this article: https://www.excel-exercise.com/how-to-highlight-birthday-automatically/