Another Interesting Conditional Formatting Solution

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
Home

Conditional Formatting in Microsoft Excel is a great tool to get information from your data quickly and easily. But sometimes as 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 formual for the conditional format:
=AND(A3<>"",A3<1.3)
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.





Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010