Set conditional formatting on entire row, based on value in a separate sheet

[wendell42]

I have one sheet that shows Sales Personnel in the columns and months down the rows. I have a total number of a specific item sold in a separate sheet.

Is there a way to set the conditional formatting for the entire row, based on the entries for each field without having to do them individually?

Basically, here is what I want to do...

Bill sold 13 of item A
Dennis sold 2 of item A
Brian sold 0 of Item A
Paul sold 3 of item A
Mary sold 8 of item A

TOTAL number of item A sold that month was 16

Based on this info, I want to set the conditional formatting to show me if any of the sales personnel were below 10% of the total items sold, but turning the number in their cell red. I can do it for each individual cell, but with 20 people and 12 months to do and numerous items for each month, that is going to take a LOT of time. Any way I can do this by selecting and setting the conditional formatting for the ENTIRE row??

Thanks in advance!

Wayne

 

[mart37]

	A	B	C	D	E	F
Name	Month	Amount	Item
Bill	apr	A
Dennis	apr	A
Brian	apr	A
Paul	apr	A
Mary	apr	A
Name	Bill	Dennis	Brian	Paul	Mary
Jan
Feb
Mrt
Apr

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]13[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]8[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"][/TD]

[TD="align: right"][/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B11: F14 =SUMIFS($C$2:$C$6,$A$2:$A$6,B$10,$B$2:$B$6,$A14) CF =SUMIFS($C$2:$C$6,$A$2:$A$6,B$10,$B$2:$B$6,$A11)<10%*SUM($C$2:$C$6)<10%*SUM($C$2:$C$6) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Select the table (B11:F14). Goto Conditional Formatting - New Rule - Formula (see CF)