In Excel, you can change automatically the colors of your cells with the conditional formatting. And you have a lot of options (icons, bars, …)
Tag Archive: Conditional formatting
Articles sur le thème : Conditional formatting
- What is a conditional formatting
- Conditional Formatting – Highlight highest values
- Conditional Formatting – Color scales
- Conditional Formatting – Data Bars and Icons
- Conditional Formatting – Highlighting dates
- How to make automatic calendar in Excel
- Weekends or weekdays in Excel
- Compare 2 Columns
- How to Highlight a Birthday Automatically
Permanent link to this article: https://www.excel-exercise.com/what-is-a-conditional-formatting/
Conditional Formatting – Highlight highest values
It’s quite easy with the conditional formatting tool to highlight the highest and lowest values of your data. Highest / Lowest value 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 and choose a …
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 …
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. …
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 …
Permanent link to this article: https://www.excel-exercise.com/highlighting-dates/
How to make automatic calendar in Excel
This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.
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 …
Permanent link to this article: https://www.excel-exercise.com/weekends-weekdays-excel/
Compare 2 Columns
You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values
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.
Permanent link to this article: https://www.excel-exercise.com/how-to-highlight-birthday-automatically/
Microsoft Award
