Excel for Marketing Managers

Math Facts Game

Math Facts
Game

c. In the third box, type in the following text: Correct!

Click on the box labeled Format, and the Format Cells dialog box will

appear. Click on the Patterns tab and choose a color, such as bright

green. Click OK to close just this box.

d. The Conditional Formatting dialog box should still be visible. On the

bottom, click on the box labeled Add>>. As before, change the second

box to “equal to”, and type in the following text in the third box:

Sorry! Try again.

e. In both of these conditions, it is absolutely imperative that you use the

exact phrase that you typed into the formula in Step 19.

Click on the Format box, then on Patterns, and select a color different

from the last time, such as pink. Click OK to close just this dialog box.

f. Click on the Add>> box again. Change the second box to “equal to”.

Then in the third box, type in the following formula: =A1&” and “&A2

Again, make sure that, when you type in this phrase, it is identical to

the same phrase in the formula in Step 19.

Figure 193

Setting up

Condition 2 in

the Conditional

Formatting

dialog box

Note:

If there is any difference, no matter how slight, in the three phrases you just typed

from how they appeared in the Step 19 formula, the cell will not change colors

correctly.