Exercise: The two data sets below list the number of movies watched per month by a movie-loving family and the medical expenses per month for a family. Use conditional formatting as follows. Note that the data have been generated by live random formulas. This highlights the effect of conditional formatting: The formatting should change as the spreadsheet recalculates (by pressing the F9 key).
1. In column B, use a Highlight Cells Rules option to change the font color to RED (from the "Standard Colors" section of the color palette) if the number of movies is greater than 15.
2. In column E, use a Highlight Cell Rules/Equal To option to change the number format for all zero values to currency with no decimals. (It should be the same currency format type as currently used in column E, except with no decimals.)