With the range E2:E30 selected, create a new conditional formatting rule that uses a formula to apply yellow fill and bold font
to values that sold for less than or equal to 70% of the sticker price. Be sure to select a Rule Type that will use a formula to determine which cells to format. 5
1 answer:
You might be interested in