Select the correct navigational path to mark all teachers who have achieved “excellent” on their evaluations a red background. Select the rows or columns you wish to format. Click the (Home, Page layout, data, view) tab on the ribbon and look in the (Clipboard, alignment, number, conditional formatting) gallery. Select (New rule, manage rule, clear rule) . Select ( format only top or bottom, format all cells, use a formula) and fill in the formula for the IF statement and formatting. Click OK.