Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I sort values only & leave orginal cell formatting?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I sort values only & leave orginal cell formatting?
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 formatconditional 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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
retrieve cell formatting with IF(HLOOKUP) formula | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can you sort text in a column, but leave cell color alone? | New Users to Excel |