Excel for Marketing Managers

Homework Checker

Homework

Checker

a. Set up the second condition similar to the first. Choose a yellow font on

a red background.

b. Click OK to close the Conditional Formatting dialog. Cell B8 looks great

when the answer is Right!, but the text in Try Again is too long.

Note:

You can only add second and third conditions. Although many people would like
this feature to handle four or more conditions, Microsoft has not yet accommodated
this need.

Figure 121

Adding a

second

condition

Figure 122

Formatting

the second

condition