Sorting Rows By Colors

G

Guest

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Background stays when sorting 2
Make text color match cell color with macro? 1
Sorting by color 2
Sorting by Color in Excel 2003 5
Apply color of one cell to other 2
Sort rows by colors 6
sort by colors 4
Coloring the cells by formula 7

Top