Is there a way to sort a table by colour but not by column?

[TheRedCardinal]

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?

 

[levipe]

The only idea that immediately comes to mind is to add a column that flags the rows that are red. Ideally it would be a formula so it wouldn't need to be manually filled. If you're manually shading these rows, I would, in general, prefer to use conditional formatting that shaded them based off of the flag column as it's faster than manually shading and you also have the column to sort by.