Dear friends,
I always have trouble for conditional formatting.
This time, I would like to highlighted the columns using conditional formatting, given a range in percentage. I have tried but to no avail.
Can anyone assist?
Student Grade
Leon 91%
Apple 112%
Simone 81%
Olivier 135%
Terence 45%
Violet 86%
Pearl 103%
Paul 122%
Pamela 138%
Andy 29%
Richard 42%
If between 0-90 Highlight Red
If between 91-100 Higlight Green
If between 101-110 Highight Orange
If >110 Highlight Blue
Bookmarks