Sorting Rows By Colors
 

Can you sort rows of different colors in categories by formula or macro?
Or
Can you make up a formula or macro like:
if cell A1 is filled with red color the result is "R" otherwise "G".

Sorting Rows By Colors
 

Check this out

http://www.xldynamic.com/source/xld.ColourCounter.html

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"FARAZ QURESHI" wrote in message
...
Can you sort rows of different colors in categories by formula or macro?
Or
Can you make up a formula or macro like:
if cell A1 is filled with red color the result is "R" otherwise "G".

Sorting Rows By Colors
 

Or, you can try this site by Pearson Sowtware Consulting Services:
http://www.cpearson.com/excel/SortByColor.htm

--
T Tipsy


"John Bundy" wrote:

Check this out

http://www.xldynamic.com/source/xld.ColourCounter.html

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"FARAZ QURESHI" wrote in message
...
Can you sort rows of different colors in categories by formula or macro?
Or
Can you make up a formula or macro like:
if cell A1 is filled with red color the result is "R" otherwise "G".