Conditional Formatting row by last column in row value

[kshines]

Wise people of the forum.. I need help. How do I Conditional Format each row separately to show the locations that exceeds the average of all locations in the row? Once it set up for the first row how do I copy it down to the remaining rows?

	Location 1	Location 2	Location 3	Location 4	Location 5	Location 6
Repair 1	$ 7.73	$ 0.83	$ 4.29	$ 8.31	$ 1.01	$ 1.10
Repair 2	$ -	$ 2.11	$ 2.60	$ 5.15	$ 1.19	$ 2.14
Repair 3	$ -	$ 0.73	$ 1.28	$ 4.32	$ 0.17	$ 1.64
Repair 4	$ 0.78	$ 0.82	$ 0.64	$ 6.75	$ 0.05	$ 0.55

<tbody>
</tbody>

Thanks you so much in advance. Your time is very much appreciated.
KH

 

[PaddyD]

assuming your data is in a1:g5, select the range b2:g5 and enter the following CF:

=b2>average($b2:$g2)

...select format as required.

 

[kshines]

assuming your data is in a1:g5, select the range b2:g5 and enter the following CF:

=b2>average($b2:$g2)

...select format as required.

Paddy,
I need each row to be independent using the values on that row to calculate an average and display by CF. I can do it using CF then selecting Above Average then set the format BUT I cannot copy to each row below. Doing it this way means I have to do several steps for each row which would make me very old...
Thanks for your time
KH

 

[PaddyD]

Have you actually tried the suggestion - it's a one-stop-shop.

 

[kshines]

Have you actually tried the suggestion - it's a one-stop-shop.

PaddyD it works and you were so right, once I understood what you were doing and used the formula properly. It's a miracle!!
Thanks much for your help.
KH

 

[PaddyD]

Glad you've got it sorted.