Finding values based on color

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

Guest

Hello,

I have a spreadsheet that has values (entire rows actually) that are colored
in blue and red to signify different circumstances. There are over 100 that
I can see so far. I would like to do a sort that only shows the rows that
are in blue, and then only the ones in red. Is this possible.

BTW, when I say in color, I mean that the font is the object colored, not
the cell.

TIA for your responses.

Phil.
 
Niek,

Thanks, I was able to use that technique successfully.

Have a great day.

Phil
 
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

Access Remove rows based on multiple fields 2
How can I add the values based the color of font and the date 1
Sum Column Based on Cell Color 5
Conditional format stoplight based on worst color 3
CountIf Condition based on lookup in a list of values 5
sum total of numbers that are a certain color? 3
EXcel 2007 - Unable to sort by font and cell colors 1
add value of cells based on the formatted fill color 3

Back
Top