Chapter 2, Problem 11RA

8. In the list of interest rates (range A13:A25), create a Conditional Formatting Highlight Cells Rule to highlight the listed rate that matches the rate for the Charles Street property (cell D4) in Light Red Fill with Dark Red Text.

Please provide a full code with screenshot of output!

Apply a conditional format to the range J9:J54 that highlights cells where the value is greater than 200% with Green Fill with Dark Green Text.