Category Archives for "Conditional Formatting"

Visual warnings with conditional formatting

In this article, I will show you how to create a visual warning using icon sets in conditional formatting.
A warning comes in many shapes in Excel. It can be the warning that pops up when you are about to close your workbook without saving. It can be a warning that shows that something has gone wrong.
But a warning is really just a message from the program to the user.
In this article, I have created a tool that calculates a huge one-time employee bonus. It is a simple calculation that is not really important for the purpose of this article. It is simply just a way of showing one of the many things conditional formatting can be used for.

Take a look at this Animation below:

Visual Warnings Animation