I presume that you mean over?

Select cells in row 31, starting with say column B, CF with formula of

=(B31-B$19)/B$1935% for red

and

=(B31-B$19)/B$1926% for yellow

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
HERE'S ANOTHER ONE FOR YOUR PROS.
I want the respective condition with each cell in row 31 to change to
yellow
when it's 26% to 35% of the respective condition with each cell in row 19.
If
the cell in row 31 is over 36% turn the cell red.
i.e.
b19 1000
b31 1300 (this should turn yellow)

c19 1000
c31 2000 (this should turn red)

Basically 1000 * 26%-35%. help me on this please.

Thanksgiving a lot!!

"SteveG" wrote:


Try

=AND(B26<"",B26=0)

This can be copied to cells C26:Z26 using the format painter. If you
want the reference in the condition to change to each cell, be sure to
remove the $'s from the formula. I here you on the Thanksgiving thing.
Luckily, half a day for me.



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=487940

Bob,
Thanks for your reply, however, I can't get it to work. The yellow
superceeds the red and vice versa, if I take the yellow formual out.

HEAT

"Bob Phillips" wrote:

I presume that you mean over?

Select cells in row 31, starting with say column B, CF with formula of

=(B31-B$19)/B$1935% for red

and

=(B31-B$19)/B$1926% for yellow

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
HERE'S ANOTHER ONE FOR YOUR PROS.
I want the respective condition with each cell in row 31 to change to
yellow
when it's 26% to 35% of the respective condition with each cell in row 19.
If
the cell in row 31 is over 36% turn the cell red.
i.e.
b19 1000
b31 1300 (this should turn yellow)

c19 1000
c31 2000 (this should turn red)

Basically 1000 * 26%-35%. help me on this please.

Thanksgiving a lot!!

"SteveG" wrote:


Try

=AND(B26<"",B26=0)

This can be copied to cells C26:Z26 using the format painter. If you
want the reference in the condition to change to each cell, be sure to
remove the $'s from the formula. I here you on the Thanksgiving thing.
Luckily, half a day for me.



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=487940