Highlight the Date outside the deadline in Excel
How to highlight the dates outside the deadline in Excel? You must use the conditional formatting and create your own rule.
Conditional formatting
How to Insert Icons in your cells
Excel allows you to add icons in your cells to show the trend of your data. Nothing is complex with the conditional formatting tool.
Copy a Conditional formatting rule
A new option in Excel 365 allows you to duplicate a conditional formatting rule. Nothing complex to do, just a new button do the job.
Conditional Formatting – Color scales
A color scale is an option for the conditional formatting of Excel. It's a useful way to present the similarity of your data.
Find Weekends or weekdays in Excel
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
Color an entire row by formula
How to color the entire row with the conditional formatting. Discover the technique, step by step in this article.
Change the color of holidays
You can change automatically the color of the public holidays in your calendar with the conditional formating and a custom rule.
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 in Excel
In Excel, you can change the color of the weekend in your workbook by creating your custom rule in the conditional formatting tool.
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
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.
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.
