gizzylover
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 55
Since the pivot table formats available to me are not desireable, I'd like to create a macro to format the "total" rows on my pivot table to bold and a shaded color.
My logic is this:
If on the pivot table, any row in columns C:E contains the word "total", then format that row (starting with column that has the word total in it) and ending with column N to be bold font text and shaded orange.
Can someone help me figure out how to do this?
My logic is this:
If on the pivot table, any row in columns C:E contains the word "total", then format that row (starting with column that has the word total in it) and ending with column N to be bold font text and shaded orange.
Can someone help me figure out how to do this?