Hi, Im pretty lost. I am trying to change the font colour of a Cell dependant
on the answer in another cell. Also, the cells which I want to change the
colour of already have a formula inside them and I want to know if I can add
another formula to a cell with a formula in it.

e.g a1= A32*34 and A7= 10, then if A7 =10 I want A1 to be Red, if not black.

I want to do this for a range of cells (i.e. A1: H1) so that if A7 gives the
number that corresponds to the result in the cell range A1:H1, it changes the
colour of the cell within the range.

Its all a bit complicated and would love any advice. Also Im not sure if it
is possible to do this for cells which already contain a formula

HELP

You do not need code, just Conditional Formatting.

Select the cell you wish to format, I am assuming A1 is the first

Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$A$7=10
Click the Format button
Select the Pattern Tab
Select red
OK
Click Add Condition
Change Condition 2 to Formula Is
Add a formula of =$A$7<10
Click the Format button
Select the Pattern Tab
Select black
OK
OK


Second

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bemused Scot" <Bemused wrote in message
...
Hi, Im pretty lost. I am trying to change the font colour of a Cell
dependant
on the answer in another cell. Also, the cells which I want to change the
colour of already have a formula inside them and I want to know if I can
add
another formula to a cell with a formula in it.

e.g a1= A32*34 and A7= 10, then if A7 =10 I want A1 to be Red, if not
black.

I want to do this for a range of cells (i.e. A1: H1) so that if A7 gives
the
number that corresponds to the result in the cell range A1:H1, it changes
the
colour of the cell within the range.

Its all a bit complicated and would love any advice. Also Im not sure if
it
is possible to do this for cells which already contain a formula

HELP