Is there a way to sot based on the color of the text or by the background
color?

I have a spreadsheet that the background is changed based on the status of a
shipment and we would like to be able to sort by the color.
--
Brooks W.

See http://www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brooks W." wrote in message
...
Is there a way to sot based on the color of the text or by the background
color?

I have a spreadsheet that the background is changed based on the status of
a
shipment and we would like to be able to sort by the color.
--
Brooks W.

Enter this small UDF:

Function clr(R As Range) As Integer
With R.Interior
clr = .ColorIndex
End With
End Function


If you data-by-background-color is in column A then enter:
=clr(A1)

in an un-used column and copy down. Then sort by the new column.
--
Gary''s Student


"Brooks W." wrote:

Is there a way to sot based on the color of the text or by the background
color?

I have a spreadsheet that the background is changed based on the status of a
shipment and we would like to be able to sort by the color.
--
Brooks W.