Conditional Format only certain Rows in Pivot

[sscornav]

I have a simple Pivot:
Jan Feb
Employee 1 100 100
Project 1 60 70
Project 2 40 30
Employee 2 90 100
Project 5 90 10
Project 8 0 90

Where employees are assigned a % of their time each month to a project.

Question: How do I conditionally format only the Employee row with values <100 WITHOUT formatting the Project rows?

Thanks!

 

[Peter_SSs]

You mentioned that the numbers were percentages so I have assumed that where you show 100 or 60 the actual values are 1 or 0.6 etc. If not hopefully you can adapt this.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Employee	Project	Month	Percentage			Sum of Percentage	Column Labels
2	Employee 1	Project 2	Jan	40%			Row Labels	Jan	Feb	Grand Total
3	Employee 2	Project 1	Feb				Employee 1	90%	100%	190%
4	Employee 1	Project 1	Feb	100%			Project 1	50%	100%	150%
5	Employee 2	Project 1	Feb	20%			Project 2	40%		40%
6	Employee 1	Project 1	Jan				Employee 2	100%	20%	120%
7	Employee 2	Project 2	Jan	80%			Project 1	20%	20%	40%
8	Employee 1	Project 1	Jan	50%			Project 2	80%		80%
9	Employee 2	Project 2	Feb				Grand Total	190%	120%	310%
10	Employee 1	Project 2	Jan
11	Employee 2	Project 1	Feb
12	Employee 1	Project 1	Feb
13	Employee 2	Project 1	Feb
14	Employee 1	Project 1	Jan
15	Employee 2	Project 2	Jan
16	Employee 2	Project 1	Jan	20%
17	Employee 2	Project 2	Feb
CF Pivot

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H3	1. / Formula is =AND(H3<1,ISNUMBER(MATCH($G3,$A$2:$A$17,0)))	Abc