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 …
Permanent link to this article: https://www.excel-exercise.com/what-is-a-conditional-formatting/
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 …
Permanent link to this article: https://www.excel-exercise.com/top-bottom/
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 …
Permanent link to this article: https://www.excel-exercise.com/color-scales/
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. …
Permanent link to this article: https://www.excel-exercise.com/data-bars-and-icons/
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 …
Permanent link to this article: https://www.excel-exercise.com/highlighting-dates/
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. …
Permanent link to this article: https://www.excel-exercise.com/how-to-make-automatic-calendar-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 …
Permanent link to this article: https://www.excel-exercise.com/weekends-weekdays-excel/
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 …
Permanent link to this article: https://www.excel-exercise.com/compare-2-columns/
