Automatic colouring of cells
 

I've set up an IF condition on a column of cells and want to colour a
separate column of cells depending on the result

e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell
F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want cell
G4 to turn green.

Sure I've seen it done before but cant work it out.

Thanks for any help.

Automatic colouring of cells
 

formatconditional format

--
Don Guillett
SalesAid Software

"plf100" wrote in message
...
I've set up an IF condition on a column of cells and want to colour a
separate column of cells depending on the result

e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell
F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want
cell
G4 to turn green.

Sure I've seen it done before but cant work it out.

Thanks for any help.

Automatic colouring of cells
 

As easy as that! Thanks Don.

"Don Guillett" wrote:

formatconditional format

--
Don Guillett
SalesAid Software

"plf100" wrote in message
...
I've set up an IF condition on a column of cells and want to colour a
separate column of cells depending on the result

e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if cell
F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want
cell
G4 to turn green.

Sure I've seen it done before but cant work it out.

Thanks for any help.

Automatic colouring of cells
 

glad to help

--
Don Guillett
SalesAid Software

"plf100" wrote in message
...
As easy as that! Thanks Don.

"Don Guillett" wrote:

formatconditional format

--
Don Guillett
SalesAid Software

"plf100" wrote in message
...
I've set up an IF condition on a column of cells and want to colour a
separate column of cells depending on the result

e.g. in column F the formula is IF((E6$D$3+30),"0","1"). So, if
cell
F4="1", I want cell G4 to turn red. Similarly, if cell F4="0", I want
cell
G4 to turn green.

Sure I've seen it done before but cant work it out.

Thanks for any help.