trying to sort just values in google spreadsheet range and I do not want to include cell background color
I have for example cell values like this: column A has test1 etc. and column B has numbers
Row test1 and test2 have background color of green and Row test3 and test4 have background color of yellow. When I sort from highest to lowest the background color follows the rows which is what I don't want to happen. So Row test3 and test4 are at the top with a background of yellow, but I need them to stay green.