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 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 Change the background color for any rate in C2 C17 that is between 3 00 and 3 30 Use a predefined rule to mark any fee in F2 F17 that is over $1100 Use the default formatting for the rule 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 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 07, 2024

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.
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.
Change the background color for any rate in C2:C17 that is between 3.00 and 3.30.
Use a predefined rule to mark any fee in F2:F17 that is over $1100. Use the default formatting for the rule.
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.

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.