Question: 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

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.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The question seems to be complete and heres a stepbystep guide to apply conditional formatting in a ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Hi there, I missed two weeks of school because of medical reasons. Can someone help me with this please? AutoSave . Off Jake's pet business - Saved Search Guillaume Etienne GE File Home Insert Page...

CERTIFICATE IV IN FINANCE AND MORTGAGE BROKING - FN540820 Page 1 UNIT 9 MANAGE PERSONAL AND PROFESSIONAL DEVELOPMENT Unit Code: BSBPEF501 This unit describes the skills and knowledge required to...

few Strategic Decisions on key issues - From the role of CEO - Spotify case study IESE Business School IES86 University of Navarra October 2021 Spotify: Face the Music (Update 2021) Govert Vroom...

Report: Your report should include: I. NSU Cover page (1 page in length). It will present the name of the case and the author(s) of the report. II. Executive Summary (1 page in length). The Executive...

Hello, I have the attached assignment due on 11/29. Could you help? TAX CONFUSION AND FORM 1040 TURMOIL It was the night of April 14 and Daniel was pacing furiously around the house muttering to...

Report Format: Your report should include: II. Executive Summary (1 page in length). The Executive Summary is a concise overview of the report. The Case Study Report should be written from the...

Use the demographic file of information page to choose the following (click HERE for the file): Marital status (remember this is some future time) Income (include spouse) Housing status from choice...

URGENT HELP NEEDED. I chose Single Help me solve this excel assignment. Use the demographic file of information page to choose the following (click HERE for the file): Marital status (remember this...

15) Write a general function script to search any text file whose name you input (ie. "C:/my_files/moby_dick.txt") and any character string (ie. "Ishmael") and a name of an output file (ie....

The w = 75+ 2L and the aggregate demand for cricket players is given by w = 315-4L aggregate supply of cricket players is given by 1. First assume that the players and the teams are all in perfect...

E19.10 (LO 1, 4, 5) (Pension Expense, Journal Entries, Statement Presentation) Henning plc sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the...

please answer only if you know programming language is c++ For this lab, your objective is to define the functions below. Define the void function SwapNodes () that takes three generic type Node...