1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
RoseWind [281]
3 years ago
14

Create a new conditional format that applies yellow fill (fourth color in the bottom row) and bold font to values that are highe

r than 98% for the percent of list price column.4
Computers and Technology
2 answers:
Yuki888 [10]3 years ago
5 0

Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and identify variances of cells' values with a quick glance.

At the same time, Conditional Formatting is often deemed as one of the most intricate and obscure Excel functions, especially by beginners. If you feel intimidated by this feature too, please don't! In fact, conditional formatting in Excel is very straightforward and easy to use, and you will make sure of this in just 5 minutes when you have finished reading this short tutorial.

Elena L [17]3 years ago
3 0

Answer:

These steps will help you create a new conditional format. My explanation will be done using Microsoft Excel 2013. Same steps apply for a higher version of Microsoft Excel

Explanation:

Step # 1 -- Name the data range. To start off the process, select the first cell of the data in your spreadsheet and press the " Shift " key and click the last cell in the column containing your data you wish to apply the conditional formatting on. The values will be selected. Now go to the "name" bar and type in the name of the range.

Step # 2 -- Select a Color Scale. Once you have selected the data, click on the "conditional formatting" button under the "styles" group in the "home" tab. Go to the “Color Scales”, in the pull menu select the fourth color in the bottom row to apply the Yellow fill.

Step # 3 -- Make a new rule. You can also make new rules by selecting the "new rule" option from the conditional formatting drop-down menu. Once done, a new box will appear where you can select the rule type, format the style and perform other such actions. In the “Select a Rule Type” click “Format only values that are above or below average” and select “above” in the “Format Values that are” field and click the “format button.

Step # 4 -- Apply the Highlight Cells Rule. Here, you can apply the "highlight cells rules" option. Once you click on this, a number of options will appear. Select the "greater than" rule and input a conditional value of 98%. All values above this conditional value will be highlighted since the condition is of "greater than". Select “bold” under “font style” and click the OK button twice.

You might be interested in
________ is malware that hijacks a user's computer and demands payment in return for giving back access.
Lera25 [3.4K]

Ransom  malware that hijacks a user's computer and demands payment in return for giving back access.

<h3>What is Ransom malware?</h3>

This is known to be a kind of  malware that hinders users from gaining in or access to their system or personal files and it is one that often demands ransom payment so as to get access.

Therefore, Ransom  malware that hijacks a user's computer and demands payment in return for giving back access.

Learn more about Ransom  malware from

brainly.com/question/27312662

#SPJ12

6 0
2 years ago
Which type of portfolio might a young investor who is not afraid of risk choose?
Keith_Richards [23]
i think it would be the investment with high risk and high return such as Stocks.When investing in stock, investor analyze whether a specific company will be doing well in the time of investment (which will increase the market price of the stock) and take a profit from it.
7 0
3 years ago
Whatisthebestlocationapp for my androidphonebesidesgoogle maps?
Cerrena [4.2K]
Not sure whether this question is requires a specific answer but I would say Waze.
3 0
3 years ago
What are some areas in Computer Science that make use of multivariate statistical testing or MCM methods? Explain why they are u
Nikolay [14]

Explanation:

Computational modeling is one of the areas of Computer Science that uses mathematical systems to perform multivariate statistical tests to solve highly complex problems in multidisciplinary areas, such as medicine, engineering, science, etc.

An example of the use of multivariate statistical tests is social development research in social science, which uses multiple variables to find more hypotheses and greater coverage between variables.

Multivariate statistical tests have the benefit of making research more effective and providing a more systematic and real view of the study.

6 0
3 years ago
Investigators are combing the site of an explosion with mesh screens to collect evidence. The explosion was very large, leaving
rewona [7]

Answer: SCANNING ELECTRON MICROSCOPY,

Explanation:Many methods are available for use in an explosion site to determine or confirm the explosive materials or bomb fragment seen or obtained from the site they include the following; SCANNING ELECTRON MICROSCOPY,

CHROMATOGRAPHY-MASS SPECTROMETRY, STEREO MICROSCOPY, CAPILLARY ELECTROPHORESIS.

SCANNING ELECTRON MICROSCOPY, is a technique used to identify or confirm a material by scanning the surface of the material using FOCUSED BEAM OF ELECTRONS IN AN ELECTRON MICROSCOPE.

6 0
3 years ago
Read 2 more answers
Other questions:
  • Candace opened an email from a person she didn't know and clicked on a pop-up in the email that installed a virus on her compute
    8·2 answers
  • Which of the following information sources was not directly affected by the Telecommunications Act of 1996?
    12·1 answer
  • What is the differnces between dark and middle ages of computer?​
    9·1 answer
  • Using a pin or password in addition to tpm is an example of what type of authentication?
    13·1 answer
  • Want is the assignmment
    8·1 answer
  • which kind of device does a computer need in order to provide information to a person or something else
    7·1 answer
  • A ____ is a device that interconnects two or more workstations in a star-wired bus local area network and immediately retransmit
    9·1 answer
  • Which of the following bit patterns represents the value -9 in two’s complement notation?
    15·1 answer
  • Could someone please explain to me the an electrical circuit.
    13·2 answers
  • The term used to describe whereby old and new media are available via the integration of personal computers and high speed satel
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!