ZuoTi.Pro
Question

Excel Question - How do I highlight the name of the fruit when the quantity is over 10? I get that we are supposed to use "conditional formatting", but I could only get it to highlight the number, not the name of the fruit.

.Apple Grape Orange Pineapple Kiwi

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Let the values start from cell A1
Cell A1 contains Apple and Cell B1 contains 5

Conditional Formatting->
New Rule->
Use a Formula to determine
=B1:B5>10
Applies to
$A$1:$A$5

0 0
Add a comment
Know the answer?
Add Answer to:
Excel Question - How do I highlight the name of the fruit when the quantity is...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Question about spark with python. I have a dataset named example.csv, here is data in CSV...

    Question about spark with python. I have a dataset named example.csv, here is data in CSV file below: [0] name [1] name of fruits [2] number of fruits 1. use Pyspark code to plot the number of each fruit. sort the result based on the number of fruits the x-axis is the name of fruits, the y-axis is num of total fruits the output should be apple 10 banana 5 orange 3 mango 2 2. use Pyspark code to plot...

  • Question 21 The loop condition can be a complex condition involving several operators. True OR False...

    Question 21 The loop condition can be a complex condition involving several operators. True OR False Question 22 final int MAX = 25, LIMIT = 100; int num1 = 12, num2 = 25, num3 = 87; if(num3-5 >= 2*LIMIT) { System.out.println ("apple"); } else { System.out.println ("orange"); } System.out.println("grape"); What prints? A. Apple B. Orange C. Grape D. apple grape E. orange grape F. Nothing. Question 23 When we use a while loop, we always know in advance how many...

  • Please help I have no idea how to do this question. Download monthly adjusted close price...

    Please help I have no idea how to do this question. Download monthly adjusted close price data for Apple and Google (Alphabet Inc.). for the period of Jan. 2010 through Jan. 2020 (use Finance.Yahoo.com). Use Excel for this question. Stock returns are computed as rt+1 = Pt+1 − Pt Pt 1. Assume that you are constructing portfolios with Apple and Google such that wA + wG = 1. Create a column in Excel and apply a range of weights between...

  • How can I make my Excel userform pull data from a "veryhidden" ( I enabled this when I get into the VBA interfac...

    How can I make my Excel userform pull data from a "veryhidden" ( I enabled this when I get into the VBA interface) Excel shee OR how can I lock certain coulmns so user cannot delete the data because my userform uses that data for combo box? I tried both methods but when I click submit on userform, it goes to the Excel sheet that it needs to put the userform information,but I get an error and it doesn't paste...

  • I have the answers I just don't know how to input the answers into a formula...

    I have the answers I just don't know how to input the answers into a formula in the excel solver so that it can accept my answers. Thank you. EXCEL 3: CHAPTER 7 x Get Homework Help With Che X → C newconnect.mheducation.com/flow/connect.html EXCEL 3: CHAPTER 7 A Saved Help Save & Exit Submit ? X - Sign In 05. Calculating stock price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW * Calibri 111 SAA = %...

  • This exercise is also from C++ How do I even figure this out? please help me...

    This exercise is also from C++ How do I even figure this out? please help me solve so I can get the answer correctly! Question 28 10 pts (SHORT ANSWER) Define a function named findEvenOrOdd that has 1 int parameter: num. When the function is called, it should use an if/else statement -OR- conditional expression to determine whether the variable num is an even or odd number and display appropriate message as follows: • If the value in num is...

  • by java langage QI A small online grocery store sells fruits with the following prices: Apple,...

    by java langage QI A small online grocery store sells fruits with the following prices: Apple, 1.500 KWD; Orange, 0.700 KWD; Banana, 1.000 KWD; Peach, 2.500 KWD; and Melon, 1.750 KWD. Write an application that reads a series of pairs of values as follows: 1. fruit name 2. quantity sold Your program should use a switch statement to determine the price for each fruit. It should then calculate and display the total retail value of all sold fruits (e.g., if...

  • I have the answers I just don't know how to input the answers into a formula...

    I have the answers I just don't know how to input the answers into a formula in the excel solver so that it can accept my answers. Thank you. EXCEL 3: CHAPTER 7 x Get Homework Help With Che X → C newconnect.mheducation.com/flow/connect.html EXCEL 3: CHAPTER 7 Saved Help Save & Exit Submit B I A Alignment Number - Cells - Editing Paste Clipboard AL U- 23 - Font : x Conditional Format as Cell Formatting Table Styles Styles for...

  • I really do not know how to do this exercise, please explain me with details how to do it and how to use the f4 File Ho...

    I really do not know how to do this exercise, please explain me with details how to do it and how to use the f4 File Home Insert Draw Page Layout Formulas Data Review View Help 1 BO Calibri Conditional Formatting LDB I VA A - Number 2 Format as Table Cells Paste lille 1921 Cell Styles Clipboard Font Alignment Styles A6 X for 1 A B C D G H I 1 1 K L M N Calculate all...

  • please explain how to get answer -how to do it in Excel Question 1 The time...

    please explain how to get answer -how to do it in Excel Question 1 The time a student sleeps per night has a distribution with mean 5.1 hours and a standard deviation of 0.5 hours. Find the probability that average sleeping time for a randomly selected sample of 42 students is more than 5 hours per night. I (keep 4 decimal places) I don't know 2 attempts You answered 0 out of 0 correctly. Asking up to 5.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT