Is there a way to Sort Data by font color or cell shading?

[FISH]

I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status will
change and I will gray them out by just shading the background of the cell
gray.

Is there a way I can sort these items by the background/shading of the cell
first and then the secondary sort be date?

So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.


Thanks.

 

[Pete_UK]

Take a look at this link:

http://www.cpearson.com/excel/SortByColor.htm

which shows how you can sort by colour.

Hope this helps.

Pete

 

[Dave Peterson]

How about an alternative?

Add an extra column and use it for an indicator. You could either sort by that
column (primary key???) or you may find that applying data|filter|autofilter so
you can hide or show what you want is even better.

 

[ebloch]

Look at free ASAP Utilities to sort by color

 

[Shane Devenshire]

Hi,

Excel 2007 allows Sort by Font color, Fill color as well as Filter by Color.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[renu98]

I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status will
change and I will gray them out by just shading the background of the cell
gray.

Is there a way I can sort these items by the background/shading of the cell
first and then the secondary sort be date?

So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.

Thanks.

Say data in Column A With Header
Select A2
Go to Insert<Name<Define
Type LCOLOR
Type In Refer
Get.cell(38,A2)
Ok
Now Type the Formula in B2
Type LCOLOR

Now Sort the Column B in Decending Order

Hardeep kanwar

 

[FISH]

hmmm, I'm new to this stuff so I couldn't understand your suggestions,
sorry.

I have a range of cells between G5:G3000 that I would like to be able to
sort by the shading of the cell.

Are you saying there is a way for a newbie like me to do this? If so, would
you explain how once more?


Thanks.

I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status
will
change and I will gray them out by just shading the background of the cell
gray.

Is there a way I can sort these items by the background/shading of the
cell
first and then the secondary sort be date?

So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.

Thanks.

Say data in Column A With Header
Select A2
Go to Insert<Name<Define
Type LCOLOR
Type In Refer
Get.cell(38,A2)
Ok
Now Type the Formula in B2
Type LCOLOR

Now Sort the Column B in Decending Order

Hardeep kanwar

 

[renu98]

hmmm, I'm new to this stuff so I couldn't understand your suggestions,
sorry.

I have a range of cells between G5:G3000 that I would like to be able to
sort by the shading of the cell.

Are you saying there is a way for a newbie like me to do this? If so, would
you explain how once more?

Thanks.







Say data in Column A With Header
Select A2
Go to Insert<Name<Define
Type LCOLOR
Type In Refer
Get.cell(38,A2)
Ok
Now Type the Formula in B2
Type LCOLOR

Now Sort the Column B in Decending Order

Hardeep kanwar

Hey

Its Very Simple

As you say that your data in the Range of G5:G3000



Select A5
Go to Main Menu
Insert<Name<Define
Type LCOLOR in names in the Workbooks
Type In Below (Refer to)
=Get.cell(38,A2)

Ok
Now Type the Formula in F5

Type =LCOLOR

Copy the Formulas From G5 to G3000

In F5:F3000 it show the numeric value if the cell in the Column in F
it show the Numeric Value Depending upon the Colour or Shading.


Now Sort the Column F in Descending Order

If this helps you click “Yes” if not Please provide the Attached file

Hardeep kanwar

 

[renu98]

hmmm, I'm new to this stuff so I couldn't understand your suggestions,
sorry.

I have a range of cells between G5:G3000 that I would like to be able to
sort by the shading of the cell.

Are you saying there is a way for a newbie like me to do this? If so, would
you explain how once more?

Thanks.







Say data in Column A With Header
Select A2
Go to Insert<Name<Define
Type LCOLOR
Type In Refer
Get.cell(38,A2)
Ok
Now Type the Formula in B2
Type LCOLOR

Now Sort the Column B in Decending Order

Hardeep kanwar

Please the ignore the previous one.

Try This



As you say that your data in the Range of G5:G3000

Select G5
Go to Main Menu
Insert<Name<Define
Type LCOLOR in names in the Workbooks
Type In Below (Refer to)
=Get.cell(38,G5)

Ok
Now Type the Formula in F5

Type =LCOLOR

Copy the Formulas From G5 to G3000

In F5:F3000 it show the numeric value if the cell in the Column in F
it show the Numeric Value Depending upon the Colour or Shading.


Now Sort the Column F in Descending Order

If this helps you click “Yes” if not Please provide the Attached file

Hardeep kanwar

 

[Daniel Haley]

I use an Excel add-in called ASAP Utilities. You should be able to find
it by searching the web. It expands Excel's built in abilities,
including the ability to sort by color.