annaisakiwi
New Member
- Joined
- May 29, 2018
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi All
I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column.
I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are visable.
Would appreciate any help at all with this.
Hopefully my post makes sense!
I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column.
I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are visable.
Would appreciate any help at all with this.
Hopefully my post makes sense!
Last edited by a moderator:
