I am trying add conditional formatting to the Rows section of a pivot table based on the results found in the values section of the pivot. I have already set the conditional formatting in the values section where if a field is blank, it gets highlighted yellow. My need is to be able to highlight the Employee name in yellow if the last Month showing on the pivot is blank ... which means the employee has been terminated. The attached picture is what the report would ideally look like when looking at results through April and through March. In both cases I highlighted the Employee names manually.
[2
Sample data:
Employee,Title,Dept,Month,Value
Amy Johnson,Manager,Sales,January,1
Amy Johnson,Manager,Sales,February,1
Amy Johnson,Manager,Sales,March,1
Dane Jones,Director,Operations,March,1
Dane Jones,Director,Operations,April,1
Dennis Cage,Manager,Marketing,January,1
Dennis Cage,Manager,Marketing,February,1
Erick Smith,VP,Sales,January,1
Erick Smith,VP,Sales,February,1
Erick Smith,VP,Sales,March,1
Erick Smith,VP,Sales,April,1