Equation to Detect Color

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

Guest

Would it be possible to write an equation to detect color? The INFO and CELL functions have various methods that hit all around what I need. Or... if someone highlights rows NOT by 'conditional formatting', how would it be possible to sort without a macro or without manually marking an additional row?

For example,
A B C D E F
1 Jones 100 200 300 400 They highlighted this row.
2 Smith
3 White
4 Brown They highlighted this row.
5 Hicks

I could add a column A and manually mark each column and then sort by descending alpha on column A. If the data list is short, then this is a quick fix. However, I've had people send me a non-Conditionally Formatted spreadsheet of 10,000+ rows. Yes, I could compose a short macro with the following:
IF <row>.EntireRow.Cells(<coord>).Interior.ColorIndex = <value> THEN ...
But, I was just wondering if there was a quick and dirty approach. :)

Thanks!
 
Yes, not built in though

http://www.cpearson.com/excel/colors.htm

--

Regards,

Peo Sjoblom


Rif said:
Would it be possible to write an equation to detect color? The INFO and
Click to expand...
CELL functions have various methods that hit all around what I need. Or...
if someone highlights rows NOT by 'conditional formatting', how would it be
possible to sort without a macro or without manually marking an additional
row?
For example,
A B C D E F
1 Jones 100 200 300 400 They highlighted this row.
2 Smith
3 White
4 Brown They highlighted this row.
5 Hicks

I could add a column A and manually mark each column and then sort by
Click to expand...
descending alpha on column A. If the data list is short, then this is a
quick fix. However, I've had people send me a non-Conditionally Formatted
spreadsheet of 10,000+ rows. Yes, I could compose a short macro with the
following:
 
Back
Top