mlmoyer
New Member
- Joined
- Sep 25, 2008
- Messages
- 15
I think I know the answer from perusing other threads, but just in case I misread ... ![Oops! :oops: :oops:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
We track monthly performance against a number of service levels. Those service levels that miss their get colored RED with conditional formatting. The formulas vary from service level to service level (e.g. some may have to be ">=" the target, others are "<=" the target.)
The various service levels are in column A, the target in column B, and the actual result for each month in columns C thru N (Jan - Dec).
Above (or below) all the service levels for each month I want to show the total service levels for that month count which are RED. Is that possible?
Thanks so much.
Mark
We track monthly performance against a number of service levels. Those service levels that miss their get colored RED with conditional formatting. The formulas vary from service level to service level (e.g. some may have to be ">=" the target, others are "<=" the target.)
The various service levels are in column A, the target in column B, and the actual result for each month in columns C thru N (Jan - Dec).
Above (or below) all the service levels for each month I want to show the total service levels for that month count which are RED. Is that possible?
Thanks so much.
Mark