Listings
Lenders
Realtors
You have a meeting with a prospective client today, and want to be prepared with several examples that highlight real estate options based on their preferences. Apply the following formatting: On the Listings sheet: 1. Change the Price in B2:B16 to red text when it is lower than the Original Price, indicating the price was recently reduced. Use absolute column references in your formula. 2. Change the background color for each row in A2:J16 where the listing has at least 4 bedrooms, at least 3 bathrooms, and more than 2100 square feet of living space. Use absolute column references in your formula. On the Lenders sheet: 1. Change the background color for any rate in C2:C17 that is between 3.00 and 3.30 . 2. Use a predefined rule to mark any fee in F2:F17 that is over $1100. Use the default formatting for the rule. 3. Use a predefined rule to change any rating in G2:G17 that is below 4.3 to have a Yellow Fill with Dark Yellow Text. On the Realtors sheet: - Change the background color for all rows in A2:H17 where the realtor has sold less than 50 or more than 400 single-family homes. Use absolute column references in your formula. \begin{tabular}{|c|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{} & \multicolumn{1}{c|}{ A } & \multicolumn{1}{c|}{C} & D & E & \multicolumn{1}{c|}{ F } & \multicolumn{1}{c|}{ G } & \multicolumn{1}{|c|}{H} \\ \hline 1 & Lender & Amount & Rate (%) & Term & Payment & Fees & Rating & \\ \hline 2 & Better Lender & $350,000.00 & 3.40 & 30 & $1,552.18 & $1,163 & 4.20 & \\ \hline 3 & Lenderific & $350,000.00 & 3.32 & 30 & $1,536.70 & $914 & 4.90 & \\ \hline 4 & Lend Fast & $350,000.00 & 3.58 & 30 & $1,587.33 & $1,249 & 3.50 & \\ \hline 5 & Len Ders & $350,000.00 & 3.15 & 30 & $1,504.08 & $1,405 & 5.00 & \\ \hline 6 & Real Lends & $350,000.00 & 3.19 & 30 & $1,511.72 & $797 & 4.60 & \\ \hline 7 & Group Lend & $350,000.00 & 3.20 & 30 & $1,513.63 & $918 & 3.65 & \\ \hline 8 & US Lenders & $350,000.00 & 3.11 & 30 & $1,496.46 & $762 & 4.40 & \\ \hline 9 & Missile Lenders & $350,000.00 & 3.13 & 30 & $1,500.27 & $701 & 5.00 & \\ \hline 10 & Money Lender & $350,000.00 & 3.38 & 30 & $1,548.31 & $835 & 4.80 & \\ \hline 11 & Mortgage U & $350,000.00 & 3.56 & 30 & $1,583.40 & $661 & 5.00 & \\ \hline 12 & Friendly Lender & $350,000.00 & 3.65 & 30 & $1,601.11 & $593 & 3.75 & \\ \hline 13 & Credit Lenders & $350,000.00 & 3.37 & 30 & $1,546.37 & $1,093 & 4.25 & \\ \hline 14 & Lend2 You & $350,000.00 & 3.11 & 30 & $1,496.46 & $1,225 & 3.85 & \\ \hline 15 & Lender Union & $350,000.00 & 3.15 & 30 & $1,504.08 & $1,174 & 4.50 & \\ \hline 16 & Local Bank & $350,000.00 & 3.36 & 30 & $1,544.43 & $1,147 & 3.90 & \\ \hline 17 & Total Lenders & $350,000.00 & 3.63 & 30 & $1,597.16 & $1,041 & 4.10 & \\ \hline \end{tabular} You have a meeting with a prospective client today, and want to be prepared with several examples that highlight real estate options based on their preferences. Apply the following formatting: On the Listings sheet: 1. Change the Price in B2:B16 to red text when it is lower than the Original Price, indicating the price was recently reduced. Use absolute column references in your formula. 2. Change the background color for each row in A2:J16 where the listing has at least 4 bedrooms, at least 3 bathrooms, and more than 2100 square feet of living space. Use absolute column references in your formula. On the Lenders sheet: 1. Change the background color for any rate in C2:C17 that is between 3.00 and 3.30 . 2. Use a predefined rule to mark any fee in F2:F17 that is over $1100. Use the default formatting for the rule. 3. Use a predefined rule to change any rating in G2:G17 that is below 4.3 to have a Yellow Fill with Dark Yellow Text. On the Realtors sheet: - Change the background color for all rows in A2:H17 where the realtor has sold less than 50 or more than 400 single-family homes. Use absolute column references in your formula. \begin{tabular}{|c|l|l|l|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{} & \multicolumn{1}{c|}{ A } & \multicolumn{1}{c|}{C} & D & E & \multicolumn{1}{c|}{ F } & \multicolumn{1}{c|}{ G } & \multicolumn{1}{|c|}{H} \\ \hline 1 & Lender & Amount & Rate (%) & Term & Payment & Fees & Rating & \\ \hline 2 & Better Lender & $350,000.00 & 3.40 & 30 & $1,552.18 & $1,163 & 4.20 & \\ \hline 3 & Lenderific & $350,000.00 & 3.32 & 30 & $1,536.70 & $914 & 4.90 & \\ \hline 4 & Lend Fast & $350,000.00 & 3.58 & 30 & $1,587.33 & $1,249 & 3.50 & \\ \hline 5 & Len Ders & $350,000.00 & 3.15 & 30 & $1,504.08 & $1,405 & 5.00 & \\ \hline 6 & Real Lends & $350,000.00 & 3.19 & 30 & $1,511.72 & $797 & 4.60 & \\ \hline 7 & Group Lend & $350,000.00 & 3.20 & 30 & $1,513.63 & $918 & 3.65 & \\ \hline 8 & US Lenders & $350,000.00 & 3.11 & 30 & $1,496.46 & $762 & 4.40 & \\ \hline 9 & Missile Lenders & $350,000.00 & 3.13 & 30 & $1,500.27 & $701 & 5.00 & \\ \hline 10 & Money Lender & $350,000.00 & 3.38 & 30 & $1,548.31 & $835 & 4.80 & \\ \hline 11 & Mortgage U & $350,000.00 & 3.56 & 30 & $1,583.40 & $661 & 5.00 & \\ \hline 12 & Friendly Lender & $350,000.00 & 3.65 & 30 & $1,601.11 & $593 & 3.75 & \\ \hline 13 & Credit Lenders & $350,000.00 & 3.37 & 30 & $1,546.37 & $1,093 & 4.25 & \\ \hline 14 & Lend2 You & $350,000.00 & 3.11 & 30 & $1,496.46 & $1,225 & 3.85 & \\ \hline 15 & Lender Union & $350,000.00 & 3.15 & 30 & $1,504.08 & $1,174 & 4.50 & \\ \hline 16 & Local Bank & $350,000.00 & 3.36 & 30 & $1,544.43 & $1,147 & 3.90 & \\ \hline 17 & Total Lenders & $350,000.00 & 3.63 & 30 & $1,597.16 & $1,041 & 4.10 & \\ \hline \end{tabular}
