You Have a Spreadsheet Containing the Sales Figures for Every

Essay

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
How can you change the color of the cells that contain values under one dollar in the lowest priced column?