Conditional Formatting

[9Redwood]

Hi All,

I was wondering if someone could help:

I have 52 columns (1 for each week) and 100 rows (count of criteria being analysed)
At the end of each row is a basic AVERAGE formula.
If the count being populated into each row is greater or less than 15% of the average count, I need all data that fits this criteria to be highlighted in red.
Is this a formula based CF? Do i have to past/special/formula 100 times so each row is formatted with CF?

Any help would be greatly appreciated.

 

[CWatts]

Assuming A1 is your "week 1" and your data starts in A2, and your average of the row is column BA, you can use the following formula for conditional formatting and set it up as you'd like

=OR(A2>=$BA2*1.15,A2<=$BA2*0.85)

You can then copy that cell (a2), highlight A2 to AZ101 and paste formats.

Hope that helps.

 

[9Redwood]

Thank you very much, works a treat!

Appreciate the quick response too.

Cheers mate.