Question

Task Instructions
+
x
For range B4:B18, create a New conditional formatting
rule that formats the top five cells in the range with an
Orange, Accent 6 cell background color (the last color
option in the top row of colors).
4:22 PM
3/25/2020
4:22 PM
2/3/2022

Answer 1

Microsoft Office Excel distributes its cells in rows and columns.

How to format the range B4:B18

The following step would apply the orange color to cells B4 through B18

1. Highlight the cell range i.e. cell B4:B18
2. Go to the home tab
3. Select new rule under the conditional formatting
4. Select format only top or bottom ranked values
5. Select top and type in amount of values
6. Select format and choose orange
7. Click Ok

Read more about conditional formatting at:

https://brainly.com/question/15768529