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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to color cells based upon a value in another cell 1
Automatically populate value of cell dependent on adajecent cell 3
Conditional Formatting - Assistance Please :( 0
Moving Cells 0
Conditional formatting / blank cells 6
cell vlue based on cell back colour 7
Automatic chart colours 2
If Formula 10

Top