Therefore, it is not recommended to use red and green together to make comparisons, which unfortunately, Excel does quite often by default.

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

Greater Than

Apply conditional formatting to the data in Column B that is greater than $2,750.$ How many values are greater than $2,750?$

Less Than

Apply conditional formatting to the data in Column $E$ that is less than $1,850.$

How many values are less than $1,850?$

Between Values

Apply conditional formatting to the data in Column $H$ that is between $1,900$ and $2,300.$ How many values are between $1,900$ and $2,300?$

Duplicates

A very useful tool in Conditional Formatting is finding duplicate values. Use Conditional Formatting to find the value that is duplicated in Column $K$ so your end user can find it easily. What is that value?

Top $10\%$

Conditional Formatting can be used to find a percentage of your data such as Top $10\%,$ Bottom $10\%,$ etc. Use the Top$/$Bottom Rules menu to format the Top $10\%$ of the observations in Column M then answer the questions below.

How many values are formatted?