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 