Question: Use conditional formatting to highlight the loans with an origination amount that exceeds the limit for that type of loan. Use the Loan Types and

Use conditional formatting to highlight the loans with an origination amount that exceeds the limit for that type of loan.
Use the Loan Types and Maximum Loan Amounts Table on the Loan Types worksheet
Highlight "Origination Amount(s)" in column E for any loans with an Origination Amount that exceeds the limit for that type of loan using a green background fill color.
You will need to use a vlookup to obtain the maximum loan amount in the conditional formatting rule. Use the named range "loantypes" in the vlookup.

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 Databases Questions!

Q:

During the war in Afghanistan, the Terraco Motor Company produced a lightweight, all-terrain vehicle code-named "J99 Terra" for the military. The company is now planning to sell the Terra to the...

Q:

A bank promotion project involves data collection from a group of customers who received a call about opening new credit lines. Demographics are the basic data, but another factor this bank considers...

Q:

Exercise 1: Analyzing Emergency Student Loans The Student Assistance office at your school provides emergency loans at simple interest. The data obtained from six types of loans and the desired...

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:

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:

Excel Practical Exercise Module 2 Note:Open a workbook and save as EX-PE2-YourName. Each exercise a worksheet Tab. Exercise 1: Analyzing Emergency Student Loans The Student Assistance office at your...

Q:

What formula should I use? Book1 ... AutoSave OFF OFF AG 2 w O ... Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibri (Bodyl 12 X [9 AI A = = = = General...

Q:

The Science and Engineering Jobs Excel file shows the number of jobs in thousands in the year 2000 and 2010 with projections for 2020 from a government study. Use the Excel file to compute the...

Q:

Steps to complete this project: Important : Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after...

Q:

Purpose: To demonstrate the ability to create a worksheet that utilizes financial functions and contains a data table. Problem: The time has come for you to purchase a car. After years of saving, you...

Q:

Open the start file EX2019-Capstone-Level3 . Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it The...

Q:

Doughty Sawmill, Inc., (DSI) purchases logs from independent timber contractors and processes the logs into three types of lumber products: Studs for residential buildings (walls, ceilings)...

Q:

What is the difference between all perils coverage and named perils coverage?

Q:

This week, we will prepare presentations defining and explaining the three key financial reports: The Balance Sheet, The Income Statement, and The Statement of Cash Flows. Based on research and what...

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

Middle-level managers in India espouse a greater belief in change and are less conservative than their American counterparts at this level.

Q:

People are becoming the principal instrument in delivering service to the customer, particularly as the service industry grows in importance.

Q:

Successful techniques are focusing directly on people instead of technologies or processes, operating on the principle that devising systems for getting the best out of people will automatically...