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.
Conditional Formatting using And in Excel?