I require to sort the sheet by fill colour, as I have a sheet with some rows hightlighted yellow and some not. What I'd like is to have all the yellow rows in one block and all the non-yellow in another block. Thought about conditional formatting (but that thought didn't last long, as I don't know how to use that either!).
Any help appreciated.
Any help appreciated.