Good morning,
I have read through many of the other threads regarding this, inGet cluding the references to "Getting Around Excels 3 Criteria Limit in Conditional Formatting", however not sure how to apply it in this instance?
On the attached sheet i have 5 columns in a scorecard, and each of those columns has 4 "levels". my problem is that the ccriteria for each level varies dependant upon which column it is in. (eg a top level score, or "Cruising at 44000 feet" in the Call Quality score is 88% or greater, whereas the same top level in the Data Quality aspect is 100%, and the top level under the productivity measure is a time based measure (less than 3 mins per PNR).
What I am trying to achieve is conditional formatting of the cell based upon the score entered. The colours are in rows 21-24.
How do I manipulate the VBA coding so it applied to one measure at a %score, another measure against a different %score, and futher measures entered by time? (the preference is for the time measures to stay as minutes & seconds rather than for example 82 seconds).
Just a bit beyond me ... i can do a entire sheet with 4 different colours, but dont know how to just do a column etc.
Thanks
Bookmarks