Conditional Formatting

[James8761]

With conditional formatting is it possible to highlight an entire row green if a given cell meets a certain criteria?

i.e. if cell F38 is greater than zero highlight Row 38 green

then on the other side if cell F38 = zero then highlight Row 38 blue


Thanks for any advice.

James

 

[BarryL]

Hi James,

go to conditional formatting and select manage rules, then click new rule.

Then select "Use a formula to determine which cells to format".

Enter the below formula into the box then click format and select the blue colour.
=AND($F38=0,NOT(ISBLANK($F38)))

press OK, and in the Applies to box select the area you want to apply this formatting to e.g. A38 to P235 (i would avoid applying it just a row as your spreadsheet would grow larger then needed).

then press apply.

repeat the same steps for the >0 and red colour with the below formula.
=$F38>0

 

[James8761]

Hi James,

go to conditional formatting and select manage rules, then click new rule.

Then select "Use a formula to determine which cells to format".

Enter the below formula into the box then click format and select the blue colour.
=AND($F38=0,NOT(ISBLANK($F38)))

press OK, and in the Applies to box select the area you want to apply this formatting to e.g. A38 to P235 (i would avoid applying it just a row as your spreadsheet would grow larger then needed).

then press apply.

repeat the same steps for the >0 and red colour with the below formula.
=$F38>0

That's excellent. Thanks very much, saves me a lot of time!