Conditional formating

[howard]

I have data in columns B to K row 6 to 29.

I have set up averages in B31 to K31

I would like to set up conditional formatting that where the data containing in rows 6 to 29 is more than 5% above the above that data will be highlightedin blue

for eg if any of the data in B6 exceeds B31 by more than 5% then B6 will be highlighted in blue. Do I need to set up a seperate conditional forrmula for each column?

Your assistance wil be most appreciated

 

[VoG]

Try selecting B6:K29 then use the CF formula

=B6>1.05*B$31

 

[howard]

Hi Peter

Thanks for the help, much appreciated