Question

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.

Answer 1

View, Cond. Form., New rule, Format

Step-by-step explanation:

:p Don't ask.

Answer 2

Click the home tab

conditional formatting

select new rule

select "use a formula"

Step-by-step explanation:

correct on edge 2020