(2) Select the C3: F22 cell area, click [Format]-[Conditional Format], where the cell value L is less than l60'', click the [Format] button, select the [Pattern] tab, select the [Light Yellow] color, and click [OK]; Click the [OK] button.
(3) Select C3 cell, hold down CtrI key, select a cell with a score greater than or equal to 60 in C3: F22 cell area, click Format-Conditional Format, where the cell value L is greater than or equal to l 90, click Format button, select Pattern tab, select light green, and click OK; Click the [OK] button.
(4) Select G3: (322 cell area, click [Format]-[Conditional Format], where the cell value L is less than l200'', click the [Format] button, select the [Font] tab, select [Color] as "Red", select [Font] as [Tilt], and click [OK]. Click [OK]; Select the student's name corresponding to the red italic score, click the [font color] drop-down arrow on the formatting toolbar to select "red", and then click the [tilt] button.