Question: Conditional formatting is a useful way to visually highlight certain data to perform a first level of analysis. Describe the two basic Conditional Formatting commands,

Conditional formatting is a useful way to visually highlight certain data to perform a first level of analysis.

Describe the two basic Conditional Formatting commands, Highlight Cells Rules and Top/Bottom Rules and give an example of how each might be used.

Highlight Cell Rules

Describe the Highlight Cell Rules conditional formatting command. Include an example of how it could be used.

Top/Bottom

Describe the Top/Bottom conditional formatting command. Include an example of how it could be used.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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 General Management Questions!

Q:

Excel - Chapter 4 - Formatting, Organizing, and Getting Data Short Answer 1. A key Excel skill is knowing how to access and convert data for use in your Excel worksheets. Explain why this is...

Q:

Conditional formatting is a useful way to visually highlight certain data. Describe two conditional formatting commands, and provide examples of how each might be used.

Q:

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

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

Hi, I need to understand how this is worked out, not just the answer. Thank you! Common-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel...

Q:

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

Q:

Please scan the SEC Plain English that I've attached. Please visit to this link.http://www.sec.gov/Archives/edgar/data/320193/000119312513416534/d590790d10k.htm#toc590790_9 Please read pages 25...

Q:

1. What is the recommended way to create a new PivotTable style that is close to an existing style? Select an answer: I Duplicate the existing style and then Modify the new style. Apply the existing...

Q:

1 Budgeted Income Statement 3 Sales 4 Cost of Goods Sold 5 Gross Profit 6 Selling Expenses 7 Administrative Expenses 8 Net Operating Income 9 10 Goal Seek 1 3 # of Unit Sales necessary to have...

Q:

Please answer questions 1-4 with provided information Required information (The following information applies to the questions displayed below.) The Munchkin Theater is a nonprofit organization...

Q:

Hillary's Handbags Manufacturing Co. produces nylon handbags and larger bags to sell to tourists visiting the Western United States and other tourist areas. The design of the two products is unique...

Q:

Arleta transfers property valued at $210,000 (basis = $190,000) to BCD Corporation in exchange for 70 percent of its stock. Georgia transfers property valued at $85,000 (basis = $75,000) and performs...

Q:

An applicant purchases a life insurance policy to avoid the forced sale of assets upon his death. What is this action called?

Q:

Eres el director ejecutivo de tu nueva empresa de bicicletas. Jim, su socio comercial, su amigo desde hace 20 aos y el Contralor de la empresa, le ha trado las finanzas comerciales del primer...