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

  In the sub-menu of the conditional formatting, you find the tool "Color Scale". This tool is very convenient to highlight your max and min data but your data must respect some rules. How to use color scales Activate this tool is very easy Select your data (it's better if you have several rows and …

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

A basic job with Excel is to easily isolate the weekends and the weekdays. This is the case when you hace to build an automatic calendar for example.  The function WEEKDAY Presentation This function returns a value between 1 and 7 corresponding to the value of the day in a week. =WEEKDAY(Date,Parameter) This function is …

Continue reading »

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

Compare 2 columns

How to compare 2 columns in Excel?  It's very simple 😄😎👍 I will show you in this post how to do this with the functions VLOOKUP for the research ISNA for the test IF to customize the final result 😉 But first, let's start with a live demo 💛❤💙💜💚 Live demo In this worksheet (yes, it's …

Continue reading »

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