Question

conditional formatting to apply a yellow fill color to the cells that represent the highest quarterly sales amount in each of the four quarters.

Answer 1

Values in cells given above the max one are highlighted. Point to Highlight Cells Rules or Top/Bottom Rules and then click the suitable option.

In the New Formatting Rule dialog box select Format top or bottom values ​​only. Select Above or Below from the drop-down list and enter the number of values ​​to highlight in the adjacent field. A data bar is a horizontal bar added to each cell, similar to a bar chart.

The color scale changes the color of each cell based on its value. Each color scale uses a two- or three-color gradient. Conditional Formatting is a tool that allows you to apply formatting to a cell or range of cells and change that formatting depending on the value of the cell or the value of a formula. For example, you can make a cell bold only if the cell value is greater than 100.

Learn more about Conditional Formatting here:-brainly.com/question/25051360

#SPJ4