Include a concurrent test with ISNUMBER
(to avoid spurious triggers where the source data may contain text)

Eg, for the green trigger, use Formula is:
=AND(ISNUMBER(A1),A1=90)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"AT" wrote:
Hi, I am using Excel 2000 and need to use Conditional Formatting to visually
represent areas of concern. I have one worksheet holding the core data,
linked to a 2nd sheet which provides a summary where the formatting is used.
I am using 3 colours to highlight data according to their value, Green,
Yellow, Red, with the following settings:

Green: 90 or above
Yellow: Between 60 and 90
Red: Between 1 and 60

So if 91 is in cell a1, the cell automatically changes to Green and so
forth. The conditional formatting works fine when data is entered directly
into the cell. However, when it is linked and the linked cell has no data in
it, it automatically turns Green when the formatting is applied. When i put
zero in on the data sheet, it comes up with a #DIV/0! error msg. I have used
the following to suppress the error msg so nothing comes up, but it fails to
correct it.

=IF('sheet2!F4="","",'sheet 2'!F3/'sheet2'!F4)

So if cell 'sheet2!F4 is blank, then nothing is input, otherwise process
F3/F4. To me, it looks like a simple process, but Excel doesnt like it.

If someone could shine some light on this, that would be much appreciated.