Excel for Marketing Managers

Homework Checker

Homework

Checker

2. Set conditional formatting parameters for the first condition.
   There is a dropdown that contains the word “between”. Select the arrow on
   the right side of this dropdown to see your other choices. Choose “equal to”
   from the dropdown.

a. After you choose equal to, the two boxes on the right side of the drop-

down change to a single box. Type the word “Right!” in that box as

shown in Figure 119.

Figure 117

Conditional

Formatting

dialog

Figure 119 Setting “equal to” value

Figure 118

Selecting Cell Value condition to be

“equal to”