Legion_1984
New Member
- Joined
- Aug 9, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- Web
I have a spreadsheet with 14,500 lines of data, I was able to apply VBA codes to remove blank rows and columns to get it down to 8,000 but I need to apply formatting to the rows (column A if it contains an account # to shade fill the whole row in the selection) and applying a top and thick bottom border to any row with "Account Total" in Column C
Capture of a sample of the data attached - this is how I would like to carry the formatting through the entire selection area - any help / guidance would be a huge help! Thanks in advance.
Capture of a sample of the data attached - this is how I would like to carry the formatting through the entire selection area - any help / guidance would be a huge help! Thanks in advance.