Excel Conditional Formatting Help

[melfineo]

I am trying to get it so that some cells on a row upto H change colour depending on whether the value in F G and H is above 0. For F above 0 I want the whole row green, G above zero row orange. H above zero red.

I have achieved this using conditional formatting
formula is
=$H$2>0 (for red)
=$G$2>0 (for green) etc.

This seems to work in that the cells in the whole row will change colour approriately. However I can work out how to fill this conditional formatting down so teh rows colours are independent of each other. At the moment every row will change re if h2 is above one, and every other h is 0.

I tried using no absolute refs =h2>0 but then only the one cell changes colour not the whole row. I am sure the solution must be simple can anyone help?

 

[SkipVought]

Hi,

Checl out the F4 key when your select a REFERENCE in a formula...
[tt]
=$H2>0 (for red)
=$G2>0 (for green) etc.
[/tt]
makes ALL the formulas ABSOLUTE to column and RELATIVE to row.


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[melfineo]

Thank you!