Is there a way to automate the colour of a cell based on the value of another
cell even though the cell I'm colouring has its own formula already?

For example, if a21 is a positive number, I want b21 to be green. If a21 is
negative, I want b21 to be red. If it's 0 then white. But B21 is already a
sum total of something else so I don't want to disrupt that formula

Hi,

Yes you can do that with conditional formatting. Select B21 and then

Format|Conditional formatting - Select 'Formula Is' from the dropdown
Enter the formula
=A210
click format and select Green OK

Click ADD and repeat the above but this time use the formula
=A21<0 and pick Red

Note that the cell will not be coloured if A21 =0

Mike

"trishb" wrote:

Is there a way to automate the colour of a cell based on the value of another
cell even though the cell I'm colouring has its own formula already?

For example, if a21 is a positive number, I want b21 to be green. If a21 is
negative, I want b21 to be red. If it's 0 then white. But B21 is already a
sum total of something else so I don't want to disrupt that formula

Conditional formatting does not disrupt formulas in cells.

CF does not change the value in a cell, just changes the color or font or
border.

Mike has given you the steps for CF.


Gord Dibben MS Excel MVP


On Fri, 11 Dec 2009 12:20:34 -0800, trishb
wrote:

Is there a way to automate the colour of a cell based on the value of another
cell even though the cell I'm colouring has its own formula already?

For example, if a21 is a positive number, I want b21 to be green. If a21 is
negative, I want b21 to be red. If it's 0 then white. But B21 is already a
sum total of something else so I don't want to disrupt that formula