Tag Archive: Conditional formatting

Articles sur le thème : Conditional formatting

What is a conditional formatting

Many Excel users are not familiar with the conditional formatting tool. But, it is the essential tool for automatically changing the color of a cell according to its value. Never change the color manually Many of you change the color of the cells manually using the formatting bar. Of course, to change the color of …

Continue reading

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

Conditional Formatting – Highlight Top Bottom values

Highest / Lowest value It’s quite easy with the conditional formatting to highlight the highest and lowest value of your series. 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 …

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

Creating a new calendar each month is a waste of time, but many people do as they think they need to rebuild it to get correct weekends and public holidays. But in fact, with few formulas, 2 conditional formatting rules, 1 dropdown list and 5 lines of VBA code, you can create an automatic calendar. …

Continue reading

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

Live demo Change some values in this worksheet (yes, it’s a worksheet 😃). You will see that the color of the cell will change depending on whether or not the value exists in column E. Compare 2 columns Comparing 2 columns in Excel is very easy. Everything is based on the whether or not VLOOKUP …

Continue reading

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

How to Highlight a Birthday Automatically

In this article, you will see how you can change color when a Birthday is coming up without using a macro. Step 1: Add today’s date First of all, add the current date in a new column using the function TODAY(). =TODAY() Step 2: Months until birthday In a new column, calculate the number of …

Continue reading

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