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...
Visual Warnings with 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...

read more
Data Validation to Reject Invalid Dates

Data Validation to Reject Invalid Dates

Hate Invalid Data Entry ? Then you need to check this out to prevent incorrect data to be entered in Excel. Here where the data Validation comes into existence. In this example, we are going to restrict data entry for Next 7 days. i.e I don't want a user to enter data...

read more

Pin It on Pinterest