LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil
 
Posts: n/a
Default Finding values based on color

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding values and displaying adjacent values willy3211 Excel Worksheet Functions 1 October 12th 05 04:49 PM
In excell be able to Sum values based on the color of the cell Ray Lewis Excel Worksheet Functions 0 October 5th 05 03:10 PM
How to change drop down values based on another cell value? puneetarora_12 Excel Discussion (Misc queries) 3 October 5th 05 11:28 AM
I have cells with diffent color fonts and need to total based on . KyaraB Excel Discussion (Misc queries) 1 April 20th 05 05:28 PM
If I have X,Y data how do I sum the Y values using a set of bins based on x values ScottBerger Excel Worksheet Functions 1 November 16th 04 11:48 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"