View Full Version : "Freeze" some rows with highlighting
Klartigue
01-27-2012, 09:14 AM
I have a pivot table in which column A has broker names and column B has buys, in descending order. Is there a way to highlight only the first top twenty rows. Essentially i want to "freeze" the highlighting to the top twenty cells. Is there a way to do this?
Klartigue
01-27-2012, 09:17 AM
Nevermind, I figured it out. You go to conditional formatting and create a new rule depending on what you want to be highlighted!
Klartigue
01-27-2012, 09:24 AM
Actually, conditional formatting does not stay when the pivot table is refreshed...any other ideas?
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.