nathanbrooks
New Member
- Joined
- Oct 18, 2012
- Messages
- 14
I am trying to get my conditional format setup correctly for a questionnaire. I want my auditors to go into a facility and plug in a score for each question. Once I do my sum to get my total score then get my average, I want to be able to color code that score. My questionnaire is 15 questions at 5 possible points each and the highest possible score being 75.
My example is below:
<tbody>
</tbody>
My example is below:
90-100% to return Green |
80-89% to Return Light Green |
70-79% Yellow 60-69% Orange 59% and below red |
<tbody>
</tbody>