TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
If I have a table that has interior formatting (specifically a colour) in cells within that table, is it possible to sort the table so that any row that has a cell with red formatting is moved to the bottom of the table?
I can do this with custom sort, but I have 30 odd columns and so is a lot of unnecessary code, if there is an easier way to do it?
If I have a table that has interior formatting (specifically a colour) in cells within that table, is it possible to sort the table so that any row that has a cell with red formatting is moved to the bottom of the table?
I can do this with custom sort, but I have 30 odd columns and so is a lot of unnecessary code, if there is an easier way to do it?