I have cells with conditional formatting where condition is 'Cell Value is
greater than or equal to 180, format cell as green."
These same cells are also pointing to another worksheet in the workbook.
Some of the referenced cells are blank. These blanks result in a 0 (zero) in
the overall worksheet. If I enter a formula of
=IF(ISBLANK('11-29'!J5),"",'11-29'!J5) and copy the formula down the column,
my conditional formatting is not working properly. The formula itself is
working great, but I cannot have 0's in the sheet as the numbers are used in
an average formula.
Any ideas?