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?

[TABLE="width: 744"]
<tbody>[TR]
[TD][/TD]
[TD] Location 1[/TD]
[TD] Location 2[/TD]
[TD] Location 3[/TD]
[TD] Location 4[/TD]
[TD] Location 5[/TD]
[TD] Location 6[/TD]
[/TR]
[TR]
[TD]Repair 1[/TD]
[TD] $ 7.73[/TD]
[TD] $ 0.83[/TD]
[TD] $ 4.29[/TD]
[TD] $ 8.31[/TD]
[TD] $ 1.01[/TD]
[TD] $ 1.10[/TD]
[/TR]
[TR]
[TD]Repair 2[/TD]
[TD] $ -[/TD]
[TD] $ 2.11[/TD]
[TD] $ 2.60[/TD]
[TD] $ 5.15[/TD]
[TD] $ 1.19[/TD]
[TD] $ 2.14[/TD]
[/TR]
[TR]
[TD]Repair 3[/TD]
[TD] $ -[/TD]
[TD] $ 0.73[/TD]
[TD] $ 1.28[/TD]
[TD] $ 4.32[/TD]
[TD] $ 0.17[/TD]
[TD] $ 1.64[/TD]
[/TR]
[TR]
[TD]Repair 4[/TD]
[TD] $ 0.78[/TD]
[TD] $ 0.82[/TD]
[TD] $ 0.64[/TD]
[TD] $ 6.75[/TD]
[TD] $ 0.05[/TD]
[TD] $ 0.55[/TD]
[/TR]
</tbody>[/TABLE]


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.