Counting Colours in Excel

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

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?
 
.. I highlight in the appropriate colour - one colour for returned on
time, one colour for returned late, another colour for cancelled.
Click to expand...

One thought is to use a col instead for "Status", data-validated with a
simple list for standard text, eg: On Time, Late, Cancelled

Then you could easily use autofilter, pivot tables, etc to track/analyse it
downstream. And if you need visual distinctions, just use CF to color it to
taste by pointing to the 3 values in this "Status" col

---
 
Back
Top