Aband sells shirts, cds, and other merchandise online. they are using excel to track sales by date and by name of the buyer. they would like for any purchases over $50 to be highlighted automatically so that they can send a special gift to those buyers.

which is the best way to make excel automatically highlight these sales?

using conditional formatting with a formula that includes "> 50"

using conditional formatting with a formula that includes "> $50"

finding each row that includes a number greater than "50" and inserting an if formula

finding each cell that has a number greater than "$50" and using the formatting tools

using conditional formatting with a formula that includes ">50"

Explanation:

As we want to change the cell format not their content, we need to do conditional formatting. We will select the column for the invopice value and highlight above 50.

This will make excel automatically highight the sales. finding cell with numbers greater than 50 will be a manual way to do it also; if latter the value of the cells decrease below 50 dollars it will remain highlight which is an undesired outcome.

The correct answer should be using conditional formatting over the range of cells with a rule that highlights cells greater than $50

Explanation: The option that states "using conditional formatting with a formula that includes '>$50' " is the closest to the rule. In excel, the band should typically enter their sales data in an organised manner so that all sales values are entered in one column/field.

So the best way to automatically highlight values greater than $50 in excel is to

1st - Highlight the column containing sales invoice values

2nd - Select the conditional formatting button on the home tab

3rd - select the option to highlight cells greater than

4th - fill the value as 50

Going forward, any sales values entered that fulfils the rule greater than $50 would be highlighted automatically.

I hope this helps.

press the paper clip and attach a file!

answer; /// blank(1); increases; blank(2); decreases;