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
1	Name	Month	Amount	Item
2	Bill	apr	13	A
3	Dennis	apr	2	A
4	Brian	apr	0	A
5	Paul	apr	3	A
6	Mary	apr	8	A
7
8
9
10	Name	Bill	Dennis	Brian	Paul	Mary
11	Jan
12	Feb
13	Mrt
14	Apr	13	2	0	3	8

<tbody>
</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)