Forum Discussion
Scottisimo
Feb 12, 2022Copper Contributor
Sorting rows with an "x" in them
I'm trying to sort my spreadsheet by multiple columns. How do I indicate to Excel that if a row has an "x" in the "A" column, then that row gets sorted to the bottom of the document? I want to b...
SergeiBaklan
Feb 12, 2022Diamond Contributor
As variant you may apply conditional formatting rule which highlight entire row or only the field with "x"
Now Sort by Color on No Fill
which gives