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...
Tag : Conditional formatting
Custom rule for conditional formatting
Create your custom rule with conditional formatting is the best way to create your own key performance indicator (KPI) and it's very easy 😉...
Display bars in the cells
You can display bars inside the cells to enhance the visualisation of the distribution or progress of your data. And you can customise your settings...
Conditional Formatting – Highlight highest values
You can easily highlight the highest or lowest values of your document with the conditional formatting. Easy to use and to manage...
Change the color of the weekends
Dates play a big role in many workbooks. With the tool conditional formatting you can create rules to highlight critical dates easily...
What is a conditional formatting
In Excel, you can change automatically the colors of your cells with the conditional formatting. And you have a lot of options (icons, bars, ...)...
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...
Insert Icons in your cells
In Excel, you can add icons in your cells to show the trend of your data. You can keep the default setting or apply your...
Create a progress bar with icons
Discover how you can create a progress bar in your Excel worksheet. All the steps explain in this article....
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....
