Can you have a formula to are driven by a color?
G Gord Dibben Apr 27, 2004 #3 Katie You are a little short on details. What do you want to do? Give us an example or two. Conditional Formatting under Format may do what you want but...........? If you want to sort or count or sum by color see Chip Pearson's pages on this. http://www.cpearson.com/excel/colors.htm Gord Dibben Excel MVP
Katie You are a little short on details. What do you want to do? Give us an example or two. Conditional Formatting under Format may do what you want but...........? If you want to sort or count or sum by color see Chip Pearson's pages on this. http://www.cpearson.com/excel/colors.htm Gord Dibben Excel MVP