A band 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?