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

  • Thread starter Thread starter FISH
  • Start date Start date
F

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.
 
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.
 
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
 
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.
Click to expand...

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
 
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.
Click to expand...

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
 
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
Click to expand...


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
 
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
Click to expand...


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
 
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.
 
Back
Top