sort by cell highlight

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several clients with a list of providers. Each client has one provider
that I have highlighted by using a yellow fill. This is the primary provider.
I want to sort my sheet my column A (client Name) and then by B (provider)
with the highlight provider being the first with that client and the rest
following alpha order....
 
hi,
sorry. you cannot sort by color alone. to do what you want
you will have to add a column that you can enter a "Flag"
by the primary provider. the flag can be any thing. 1 or p
or pp or some marker that excel can see to sort by.
 
You must log in or register to reply here.

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

Sorting Macro 4
Excel Highlighting duplicates 0
Conditional Formatting for 6 month intervals (ignoring day and year)?? 0
Conditional Highlight 16
conditional format on column based on cell value 2
Sort a Spreasheet by Color Highlights? 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional cell highlighting 1

Back
Top