Filter by color

Al Chara

MrExcel MVP

Joined

Feb 21, 2002

Messages

1,701

• Jul 29, 2002

• #2

You are going to have to use a VBA solution. Take a look at the following page:
http://www.cpearson.com/excel/colors.htm

 

Upvote 0

M

mvieke

New Member

Joined

Jul 25, 2002

Messages

14

• Jul 29, 2002

• #3

Do you want (for example) to sort the cells so that the RED ones are on top then BLUE, GREEN etc..?

 

Upvote 0

D

dfmor

New Member

Joined

Jul 28, 2002

Messages

9

• Jul 29, 2002

• #4

On 2002-07-29 10:15, mvieke wrote:
Do you want (for example) to sort the cells so that the RED ones are on top then BLUE, GREEN etc..?

Click to expand...

He is using four colors. If filtering is out of the question, he would like to sort in this order: green, blue, yellow, and red.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Jul 29, 2002

• #5

If your cells with a colored patterns are in column A, with cell A2 selected create a defined name, Color_Val, that refers to the formula, =GET.CELL(38,Sheet1!$A2). Now you can create a new column in your data list using the formula...

=Color_Val+RAND()*0

You can Filter or Sort on this new column.

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Jul 29, 2002

• #6

Also have a look at Harlan Grove's ExtCell, which extends the CELL worksheet function. It's available at:

ftp://members.aol.com/hrlngrv/ExtCell.zip

To add this to your WB:

"Go to the VBE (Alt F11), click on File | Import, and browse for the .bas file."

=extcell("backgroundcolor",A1)

will give you the A1's color index number.

From here, follow Mark W.'s instructions depicted in his reply.

 

Upvote 0

D

Dave Hawley

Rest in Peace

Joined

Feb 28, 2002

Messages

1,582

• Jul 29, 2002

• #7

Hi dfmor

I have a Custom Function here: http://www.ozgrid.com/VBA/Sort.htm that it used to sort by color. You should find it helpful.

 

Upvote 0

D

dfmor

New Member

Joined

Jul 28, 2002

Messages

9

• Aug 1, 2002

• #8

Thanks Al, mvieke, Mark, Aladin, and Dave for your help. I'm put on other projects now and will return to this problem soon but I'm sure one or more of your solutions will help me out. Again, thanks for taking the time to answer. This board is great

 

Upvote 0