Dear Experts,
I need a if formula that solve my problem with conditional Formatting.
Like, Production scores reports grading on below Illustration:
i) less then 33% Grade Result F and showing in red
ii) 34% to 40% Grade Result E and showing in yellow
iii) 40% to 50% Grade Result D and showing in Green
iii) 50% to 60% Grade Result C and showing in Blue
iv) 60% to 70% Grade Result B and showing in Orange
v) 70% to 80 % Grade Result A and showing in Orange
vi) 80% to 100 % Grade Result A+ and showing in orange.
I need a formula for result (A+, A, B, C, D, E, F) and (color of condition formatting).
Regards
Navi_G
Bookmarks