hello! I've searched Google for an answer but I don't think I am posing the question correctly. I have a simple excel spreadsheet (Excel 2013) that contains guest information. When the guest has left, we grey out the whole row, not just the columns that have information.
The problem is when I sort the information. Currently we only have information in columns a-q, however, need the ability to use more columns as needed. When I highlight the whole spreadsheet or just certain rows and sort, usually just by agent (column b), the spreadsheet sorts correctly however with the rows that are shaded, only the columns a-q stay shaded and with any other column past q, the shading stays with the row number and not with the original content. I've looked into conditional formatting but that's formula driven which doesn't work in our case.
Solved by A. J. in 21 mins