Hi
you can't reference cells in a different worksheet within conditional
formatting. You have to use a defined name for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Pat Z." <Pat schrieb im Newsbeitrag
...
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?