Hey guys- trying to get this thing to work, but, it's just staying white.
Any ideas as to what's wrong with it? I have this inserted in the 'Formula
Is' part of Conditional Formating- obviously without the =Green or =Red
remarks. Any ideas?


=OR(AND(BC2<=100000,BG<=0.7),AND(BC2100000,BC2<=1 40000,BG<=0.75),
AND(BC2140000,BC2<=180000,BG<=0.8), AND(BC2180000,BG<=0.85))
=GREEN

=OR(AND(BC2<=100000,BG0.7),AND(BC2100000,BC2<=14 0000,BG0.75),
AND(BC2140000,BC2<=180000,BG0.8), AND(BC2180000,BG0.85))
=RED


Thank you!
D

Hi D,

Your 'BG' references lack a row number.

Cheers


"D" wrote in message news:MMjSc.26675$Oi.1151@fed1read04...
Hey guys- trying to get this thing to work, but, it's just staying white.
Any ideas as to what's wrong with it? I have this inserted in the 'Formula
Is' part of Conditional Formating- obviously without the =Green or =Red
remarks. Any ideas?


=OR(AND(BC2<=100000,BG<=0.7),AND(BC2100000,BC2<=1 40000,BG<=0.75),
AND(BC2140000,BC2<=180000,BG<=0.8), AND(BC2180000,BG<=0.85))
=GREEN

=OR(AND(BC2<=100000,BG0.7),AND(BC2100000,BC2<=14 0000,BG0.75),
AND(BC2140000,BC2<=180000,BG0.8), AND(BC2180000,BG0.85))
=RED


Thank you!
D




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004

D,

Also, if this will be applied to more than one column, and only column BC is
the determining column, you need absolute references.

=OR(AND($BC2<=100000,$BG2<=0.7), ...

BC2 should be the active (white) cell of your selection if more than one
cell is selected.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"D" wrote in message news:MMjSc.26675$Oi.1151@fed1read04...
Hey guys- trying to get this thing to work, but, it's just staying white.
Any ideas as to what's wrong with it? I have this inserted in the 'Formula
Is' part of Conditional Formating- obviously without the =Green or =Red
remarks. Any ideas?


=OR(AND(BC2<=100000,BG<=0.7),AND(BC2100000,BC2<=1 40000,BG<=0.75),
AND(BC2140000,BC2<=180000,BG<=0.8), AND(BC2180000,BG<=0.85))
=GREEN

=OR(AND(BC2<=100000,BG0.7),AND(BC2100000,BC2<=14 0000,BG0.75),
AND(BC2140000,BC2<=180000,BG0.8), AND(BC2180000,BG0.85))
=RED


Thank you!
D

DOH! LOL- perfect! Thank you guys!
D


"Earl Kiosterud" wrote in message
...
D,

Also, if this will be applied to more than one column, and only column BC
is
the determining column, you need absolute references.

=OR(AND($BC2<=100000,$BG2<=0.7), ...

BC2 should be the active (white) cell of your selection if more than one
cell is selected.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"D" wrote in message news:MMjSc.26675$Oi.1151@fed1read04...
Hey guys- trying to get this thing to work, but, it's just staying
white.
Any ideas as to what's wrong with it? I have this inserted in the
'Formula
Is' part of Conditional Formating- obviously without the =Green or =Red
remarks. Any ideas?


=OR(AND(BC2<=100000,BG<=0.7),AND(BC2100000,BC2<=1 40000,BG<=0.75),
AND(BC2140000,BC2<=180000,BG<=0.8), AND(BC2180000,BG<=0.85))
=GREEN

=OR(AND(BC2<=100000,BG0.7),AND(BC2100000,BC2<=14 0000,BG0.75),
AND(BC2140000,BC2<=180000,BG0.8), AND(BC2180000,BG0.85))
=RED


Thank you!
D