Ok, I was working on something earlier that I posted here that takes values that end in 000 and 000) and highlight them in yellow and bold them, this was the final code:
It does what I want, goes through pivottables in 6 different worksheets and formats those cells that have numbers ending in 000 or 000). I'm now trying to write a macro that will go through those worksheets and if any row in that pivottable has a highlighted/bold cell, to go into column B of that specific row and highlight that cell yellow as well. Once it does that, the macro has to hide the rows in the pivottable that aren't highlighted or bold and also the columns that aren't highlighted or bold.
Column B contains project names and basically I want these macros to go through these tables and only show the costs that end in 000 or 000) along with the project name that the cost was allocated to. I hope this makes sense. I've tried a few lthings but can't quite get them to work.
Bookmarks