Can you sort by format or color?

  • Thread starter Thread starter Keith
  • Start date Start date
K

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???
 
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
 
Back
Top