Sorting with color

[keithfender]

Hello again gang!

Today's question is a bit different than any of the usual ones.

Is there a way to sort data by it's fill color? There is a really large worksheet, and I need to pull data for items that someone has highlighted in pink.

I was hoping that I might be able to sort a couple columns by their fill color, so all the things I need to look up return all grouped together.

Is this possible?

Thank you, as always,

-Keith

[contaminated]

I remember doin smth like this in 2007. U'r able too if u use it also.

[shg]

You can use a function to retrieve the color index, and then sort by that:

Please Login or Register  to view this content.

=CI(A1)

[keithfender]

ContaminatedWitExcel:
I use 03 at work.

shg:
Is this a macro? I am somewhat clever with formulas, but I'm clueless with macros. How to use this? Sorry for the bother, but it would be a great help if I could get this to work.

[ChemistB]

It is a User defined function which will be used in your workbook just like any other function once you have pasted the code into a VBA module.

1. Open the VBA Editor (ALT + F11)
2. Menu Insert > Module
3. Paste code

Then return to your worksheet and in an empty column adjacent to your data you want to sort,

Please Login or Register  to view this content.

Then fill down and sort by that column. Does that work for you?