Respuesta :
Answer:
Conditional formatting will enable her to highlight the records with sales in excess of 100.
Explanation:
On the ribbon home button select conditional formatting. A menu will open to select highlight type.Next select a conditional operator. You can select an operator from that menu or define your own custom rule.Next select column to apply rule on and specify color coding(green) for matched results.Press Ok and close window. Now all the cell with sale in excess will be highlighted in the color coding specified earlier(green).
Answer:
Conditional formatting
-----------------------------------------------------------------------------------------------------------------