Conditional formatting a range

[adame]

Hi, I would like to format cells b2:d16 based on the value of corresponding cells in f2:h16. I would like cells in b2:d16 to be filled red if corresponding cells in f2:h16 greater than 0 (zeros are "-") and less than/= 25, and green if greater than/= 75. I've been trying for ages and no luck. Help greatly appreciated. I have manually coloured first data row in attached.

Many thanks,

Adam

[Glenn Kennedy]

Use this:

=AND(F2>0,F2<=25)

and this:
=AND(F2>0,F2>=75)

[Pete_UK]

Select all the data from B2 to D16, then click on Conditional Formatting | New Rule | Use a formula... ,then put this formula in the dialogue box which pops up:

=AND(F2>0,F2<=25)

Then click on the Format button | Fill tab and choose red, then OK your way out.

Repeat for the same selection, but use this formula:

=F2>=75

and set the colour to green.

Excel will automatically adjust those cell references to suit the selected cells, so you only have to set this up once.

Hope this helps.

Pete

[adame]

Thanks both, that's sorted and I appreciate your help, I do find conditional formatting so complicated!

[Pete_UK]

Glad to help - thanks for the rep.

Pete