Conditional formatting is a great boon to Excel users. One use is that you can use it to highlight cells that contain zero values. However, if a cell is blank, Excel also considers that cell to be equal to zero. This tip explains how you should perform your conditional test to get only those cells containing an actual zero value. Provided by ExcelTips, a free weekly productivity ne conditionalexcelformattingmicrosoftoffice in Technology > Microsoftwith blankconditionalexcelformattingspreadsheetzeroby 2 users