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/
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 …
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/
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 …
Permanent link to this article: https://www.excel-exercise.com/weekends-weekdays-excel/
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 …
Permanent link to this article: https://www.excel-exercise.com/compare-2-columns/
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 …
Permanent link to this article: https://www.excel-exercise.com/how-to-highlight-birthday-automatically/
