Navi_G
Board Regular
- Joined
- May 30, 2018
- Messages
- 94
- Office Version
- 2016
- Platform
- Windows
Dear Experts,
I need a if formula that solve my problem with conditional Formatting.
Like, School scores grading on below Illustration</SPAN>:
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![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I need a if formula that solve my problem with conditional Formatting.
Like, School scores grading on below Illustration</SPAN>:
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