software

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 www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Brooks W.quot; gt; wrote in message
...
gt; Is there a way to sot based on the color of the text or by the background
gt; color?
gt;
gt; I have a spreadsheet that the background is changed based on the status of
a
gt; shipment and we would like to be able to sort by the color.
gt; --
gt; Brooks W.
Enter this small UDF:

Function clr(R As Range) As Integer
With R.Interior
clr = .ColorIndex
End With
End FunctionIf 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 Studentquot;Brooks W.quot; wrote:

gt; Is there a way to sot based on the color of the text or by the background
gt; color?
gt;
gt; I have a spreadsheet that the background is changed based on the status of a
gt; shipment and we would like to be able to sort by the color.
gt; --
gt; Brooks W.