Question

Application-Based Questions
a. Consider the given worksheet and answer the following
questions:
i. How will you copy the formatting of cell B2 to cells
C2:E2?
North South
2
55​

Answer 1

Not sure

But I think it is north south

Answer 2

Answer:

South

Explanation:

For example, below I have an example where I have student’s scores and I have used conditional formatting to highlight all the scores that are above 80.

If you’re interested in learning all the amazing things you can do with conditional formatting, check out this tutorial where I show some useful conditional formatting examples.

Once you have set the conditional formatting rules for a cell or range of cells, you can easily copy it to other cells on the same sheet or other sheets.

In this tutorial, I will show you how to copy conditional formatting from one cell to another cell in Excel. I will cover multiple ways to do this – such as simple copy-paste, copy and paste conditional formatting only, and using the format painter.