0:00
Here's how to highlight marks using conditional formatting
0:03
Select all the marks, go to conditional formatting, click highlight cell rules, more rules, select
0:08
greater than or equal to, right 40 here, click on format, select this green color, click
0:13
ok and ok again. Go to conditional formatting again, highlight cell rules, more rules, select less than
0:20
right 40 here, click on format, select this red color, hit ok and ok again
0:26
And there you have conditional formatting in excel
