adding color to cells based on a formula
 

Have a very simple problem, at least im sure it will be simple for
someone. I would like to add color to cells based on the value that is
in those cells, but the value also must be compared to another cell to
determine if it needs to be shaded. For example, I would like the shade
B2 if it is a positive value, and the value in A2 is negative. However
the values in these cells was already derived by using a formula, and i
dont know how to combine these two formulas. any suggestions?


--
fyrfytr265
------------------------------------------------------------------------
fyrfytr265's Profile: http://www.excelforum.com/member.php...fo&userid=2203
View this thread: http://www.excelforum.com/showthread...hreadid=480769

adding color to cells based on a formula
 

Hi!

Select cell B2

Goto FormatConditional Formatting
Formula is: =AND(ISNUMER(B2),B2=0,A2<0)
Click the Format button
Select the style(s) desired
OK out

Biff

"fyrfytr265" wrote
in message ...

Have a very simple problem, at least im sure it will be simple for
someone. I would like to add color to cells based on the value that is
in those cells, but the value also must be compared to another cell to
determine if it needs to be shaded. For example, I would like the shade
B2 if it is a positive value, and the value in A2 is negative. However
the values in these cells was already derived by using a formula, and i
dont know how to combine these two formulas. any suggestions?


--
fyrfytr265
------------------------------------------------------------------------
fyrfytr265's Profile:
http://www.excelforum.com/member.php...fo&userid=2203
View this thread: http://www.excelforum.com/showthread...hreadid=480769

adding color to cells based on a formula
 

fyr

Select B2 and FormatConditional FormattingFormula is........

=AND(A2<0,B2=0)

Select a pattern from format and OK your way out.


Gord Dibben Excel MVP

On Mon, 31 Oct 2005 23:25:49 -0600, fyrfytr265
wrote:


Have a very simple problem, at least im sure it will be simple for
someone. I would like to add color to cells based on the value that is
in those cells, but the value also must be compared to another cell to
determine if it needs to be shaded. For example, I would like the shade
B2 if it is a positive value, and the value in A2 is negative. However
the values in these cells was already derived by using a formula, and i
dont know how to combine these two formulas. any suggestions?