I think you've found a bug. I ran the numbers 1 to 46000 down a column and
then copy/pasted 1 to 10 a couple times down to have some duplicates. I
used conditional formatting to highlight the duplicates and that worked
fine. Next I selected the column and clicked the Sort button on the Data
tab. As I write it's been close to 5 minutes and the sort dialog has yet to
appear.
Since this doesn't seem to work you need an alternative. Maybe you could
remove the conditional formatting, then sort normally, which will bring the
duplicated together, and then apply the duplicates conditional formatting...
--
Jim
| Hi Jim,
|
| Just the one color and only appears in one column. I used conditional
| formatting to generate the background color though (there's a Show
Duplicates
| one). Maybe that's causing it.
|
| I've tried to copy the column and paste it again but it doesn't keep the
| cell colors. I just want it to find the duplicates, set the cell colour,
then
| sort by it.
|
| Any ideas?
|
| Thanks.
|
| "Jim Rech" wrote:
|
| > I hadn't tried sorting by color (cell fill color) before (new XL2007
| > feature) so I created a 46000 row by 3 column 'database' with two fill
| > colors in the first column. It sorted in less than 5 seconds on a
lesser
| > machine than yours. So what's different? Massive workbook otherwise?
Is
| > it slow to calc in general? (There is calc after a sort of calc mode is
| > automatic). Large number of colors?
| >
| > --
| > Jim
| > | > | Hi,
| > |
| > | I have Excel 2007 with a fairly new computer and 2gb of RAM. When I
try to
| > | sort a spreadsheet by cell color, the program locks up and I have to
quit.
| > | There are 46000 records in the sheet - I understand this is a big ask
for
| > the
| > | computer but with 2gb of RAM it should be able to do it.
| > |
| > | Does anyone have any suggestions as to how I can make this work
better?
| > |
| > | Thanks.
| >
| >
| >
