wilkies0106aw
New Member
All,
I have a pivot table which connects to external data and refreshes on opening. I can conditional format cells based on a value, yet how can I conditional format entire rows based on a cell value?
I want to actually hide the referencing column/cell value, but still somehow be able to apply the CF to the entire row.
Thanks
W
I have a pivot table which connects to external data and refreshes on opening. I can conditional format cells based on a value, yet how can I conditional format entire rows based on a cell value?
I want to actually hide the referencing column/cell value, but still somehow be able to apply the CF to the entire row.
Thanks
W