Conditional Format only certain Rows in Pivot

sscornav

Board Regular
Joined
Mar 20, 2010
Messages
125
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!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
ABCDEFGHIJ
1EmployeeProjectMonthPercentageSum of PercentageColumn Labels
2Employee 1Project 2Jan40%Row LabelsJanFebGrand Total
3Employee 2Project 1FebEmployee 190%100%190%
4Employee 1Project 1Feb100%Project 150%100%150%
5Employee 2Project 1Feb20%Project 240%40%
6Employee 1Project 1JanEmployee 2100%20%120%
7Employee 2Project 2Jan80%Project 120%20%40%
8Employee 1Project 1Jan50%Project 280%80%
9Employee 2Project 2FebGrand Total190%120%310%
10Employee 1Project 2Jan
11Employee 2Project 1Feb
12Employee 1Project 1Feb
13Employee 2Project 1Feb
14Employee 1Project 1Jan
15Employee 2Project 2Jan
16Employee 2Project 1Jan20%
17Employee 2Project 2Feb
CF Pivot
Cells with Conditional Formatting
CellConditionCell FormatStop If True
H31. / Formula is =AND(H3<1,ISNUMBER(MATCH($G3,$A$2:$A$17,0)))Abc
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top