Can I sort values only & leave orginal cell formatting? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Alyssa 3/7/2006 7:48 PM PST   Question   I have alternating rows of 'no fill' (white) & 'pattern fill' (grey) cells. I want to sort rows according to surnames but leave the formatting as is. Is this possible?     Was this post helpful to you?         Reply |   Top           Peo Sjoblom 3/7/2006 8:29 PM PST   Answer   Yes, but not with regular formatting, remove the formatting you have then select from the first to the last cell (so if the first that you want blank or no colour is A2 and the last is A50 select that range), do format>conditional formatting, formula is and use =MOD(ROW(1:1),2)=0 now click the format button and select patterns, select grey and click OK twice Sort until the cows come home and it stays the same -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Alyssa" <Alyssa@discussions.microsoft.com> wrote in message news:92F51482-5E84-4C81-A8DF-088C802D20BC@microsoft.com... >I have alternating rows of 'no fill' (white) & 'pattern fill' (grey) >cells. > I want to sort rows according to surnames but leave the formatting as is. > Is > this possible?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies