Excel for Marketing Managers

Homework Checker

Homework
Checker

b. Click the Format... button in the lower right area of the dialog. There

are three tabs on the Format Cells dialog, one each for Font, Border,

and Patterns. Choose a green color on the Patterns tab and change the

font color to blue on the Font tab.

3. Add a second conditional format and set parameters.
   You have now set up a format for when the answer is correct. You can add a
   second condition to handle the answer if it is not correct. On the Condi-
   tional Formatting dialog, choose the Add... button to add a second condi-
   tion.

Figure 120

Selecting color and pattern

formats for correct answers