Try this formula in the CF

=--J12<100

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Conditional Formats" wrote
in message ...
=Wafer_Count!H6 where Wafer_Count is a different tab in the WB

H6 on that tab is:

='\\f17epdr1\Area_Reports\C4\MRC_Status\[MRC_Status.xls]Wafer_Count'!H6

If i actually type in a negative number it recongizes that it is less then
100 but the lookup value gives it a hard time.

"Bob Phillips" wrote:

That looks fine, what is the formula in J12.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Conditional Formats"
wrote
in message ...
j12200 shade green
j12=100 shade yellow
j12<100 shade red

"Bob Phillips" wrote:

What are your CF conditions, and in what order?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Conditional Formats" <Conditional
wrote
in message ...
I'm having an issue getting my condtional format to read negative
numbers.
The format is if the reference cell is less then 100 fill the box
red.
The
reference cell is a lookup value. The conditional format works for
everything
including zero but once you hit -1 it goes back to green (a
different
conditional format for 100)