Visit Chip site at www.cpearson.com . He has VBA code to count by colour.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carla" wrote in message
...
I currently have a workbook that I add a new worksheet to each week. I am
trying to track work orders - how many, if they are returned within a
suitable time frame and if work gets cancelled. My system right now is
pretty
basic - download list from our database onto an excel spreadsheet which is
added to the main workbook. As the paper copies of the work orders are
returned, I highlight in the appropriate colour - one colour for returned
on
time, one colour for returned late, another colour for cancelled. I want
to
be able to calculate a percentage if work orders returned on time. I
would
also like to sort them if at all possible, so that the ones that aren't
coloured (not returned yet) are all together. Am I able to do this from
this
system that I currently use? If not, does anyone have any better
suggestions
that don't involve knowledge of programming?