7)Use conditional formatting to place three-way arrows highlighting composite credit appraisal scores. The up arrow should represent a score of 1, the horizontal arrow should represent a score of 2, and a down arrow should represent a score of 3 or higher.

8)Use conditional formatting to highlight the cells in the range G3:I17 that contain a value of False with light blueshading, and highlight the cells that contain a value of True with light yellow shading.

PO 527 Bidder List Financial Evaluation D&B Composite Previous Credit D&B D&B Stress Experience Net Worth Appraisal PAYDEX Risk Class Bidder List Grade (Dollars) (1 Best) (100 Best) (1 Best) Rule 1 Ribba Technology Satisfactory $ 5,000,000 1 89 1 False TDR Corporation Satisfactory 286,000 2 79 1 False ComputerX Assoc. Satisfactory 4,560,000 1 93 3 True Exceed WR None 1,089,000 3 45 1 False Roberts Inc Unsatisfactory 23,459,000 2 68 2 False Rule 2 True False True False False Rule 3 True True True True False