Automatic colouring of cells

P

plf100

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.
 
Top