ExcelUser1148
New Member
- Joined
- Mar 10, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I would like to have it so that if a condition is met, the entire row/record in a pivottable is highlighted green.
However, I cant figure out a way to do this as regular conditional formatting breaks the moment you change anything in the table (e.g adding new records or filtering)
and aside from the fact I can't figure out how to get the range to be the "select cells related to "Score" " or whatever your pivotTable fields are, I don't think that would apply it to the entire row so wont colour the entire row, right?
Anyone know of a way to conditionally highlight entire rows?
However, I cant figure out a way to do this as regular conditional formatting breaks the moment you change anything in the table (e.g adding new records or filtering)
and aside from the fact I can't figure out how to get the range to be the "select cells related to "Score" " or whatever your pivotTable fields are, I don't think that would apply it to the entire row so wont colour the entire row, right?
Anyone know of a way to conditionally highlight entire rows?