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?

What will be an ideal response?

This type of formatting is called conditional formatting. To apply conditional formatting, highlight the column containing the lowest cost item from each sale. Click the Conditional Formatting button in the Styles group, point to Highlight Cells Rules, then click Less Than. Enter 1.00 in the Less Than dialog box, then choose a color format in the dialog box. Click OK. All cells with a value less than $1.00 will have a color applied to them.