Coordinate Grid Matching
Coordinate
Grid Matching- Apply conditional formatting to smiley face cell.
Click on any of the newly colored cells and type in a capital letter J. You
should see a smiley face in the cell. To make this cell stand out a bit more,
you can use conditional formatting.
a. Highlight the cell range A1:E5 (all the cells that are green). From the
drop down menus at the top of the worksheet, choose Format and then
Conditional Format.b. A dialog box will appear. Keep the default value in the first box of “Cell
Value Is”. Click on the down arrow in the second box. Notice all of the
different conditions that you can choose from. Select “equal to”.Figure 147
Using the Format Cells dialog
to format the selected range