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/

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/

The WEEK functions

Problems of calculation with week The first problem it’s the weekends (you know, these days we stay quiet at home watching TV). We can not include these days in a work day calculation. And do you know that for some countries in the world, the weekend is not Saturday and Sunday? Yes, some Arabic countries …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/the-week-functions/

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/