Interesting Conditional Formatting Solution in Excel

Another Interesting Conditional Formatting Solution
Conditional Formatting in Microsoft Excel is a great tool to get information from your data quickly and easily. But sometimes as we can see in the training video some additional things happen which can confuse the user. The spreadsheet application, however, has a good solution even to this interesting twist.
The question of the student was as follows: If cell value is <1.3, then cell pattern(color) is red. The formatting works fine. But all the blank cells are made red as well. How can I avoid the blank cells from changing color?
Assuming that the data starts at cell A3, we apply the following formula for the conditional format:
Here we are telling Microsoft Excel to format the cells which have a value less than 1.3 and are not blank or empty. Only when both the criteria are true the cells get highlighted correctly.

Further reading:
Conditional Formatting using And in Excel?

One thought on “Interesting Conditional Formatting Solution in Excel

  1. Pingback: Calculations Conditional Formatting Counting with VBA | Excel VBA Training Videos

Leave a Reply

Your email address will not be published. Required fields are marked *