Is there any way for me to sort data by the backround colour of the cell? I
have hourly temperature data for a period of 10 years. I need to sort this
data into temperature ranges, for example 5 - 10 F, 10 - 15 F, 15 - 20 F...
I also need to separate the data into weekdays, weekend days, week nights,
and weekend nights. I've colour coded the backround depending on the day
type.

Hi Andrew,

See Chip Pearson's page on counting and summing by colour at:

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


---
Regards,
Norman


"Andrew" wrote in message
...
Is there any way for me to sort data by the backround colour of the cell?
I
have hourly temperature data for a period of 10 years. I need to sort
this
data into temperature ranges, for example 5 - 10 F, 10 - 15 F, 15 - 20
F...
I also need to separate the data into weekdays, weekend days, week nights,
and weekend nights. I've colour coded the backround depending on the day
type.