Can you sort by format or color?

[Keith]

I've got a spreadsheet where color was used in cells to
indicate correct vs incorrect responses. A red cell
indicates an incorrect response, a green indicates a
correct response. My question is, does anyone know if/how
I can write a formula that uses the cell/text color it
self as an identifier?? For example, if someone answered a
question correctly, the cell would be green. I'd like to
have a formula that would recognize the green text, and
place the number 1 in the cell next to the response. Does
anyone know how to do this???

 

[Gord Dibben]

Keith

If the colors are returned due to Conditional Formatting you could sort on
those conditions.

i.e. How do you designate what is "correct" or "incorrect"? Is there a
column or row that states "correct" or "incorrect"? Or "yes" or "no"?

If none of the above, you will need VBA code.

See Chip Pearson's SortbyColor code.

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

Gord Dibben XL2002