Question

Q4. Write the steps of conditional formatting to fill green color for cells if they contain values
greater than 50.
[5]

Answer 1

Answer:

• Here you can change the ‘Rule Type’. If you don’t want the conditional formatting to apply when “something” happens in a cell.

Hope it will be helpful ✌️

Answer 2

Answer:

Steps to apply conditional formatting to a range of cells:

1. Select the range of cells

2. Then click the Conditional formatting button in the styles group of Home tab. The drop-down menu appears

3. Click the Highlight cell Rules option for formatting the cells.

4. A menu appears showing various condition. Select the desired condition (i.e Greater than...option)

5. A dialog box appears. Enter the value 100

6. Click the drop down arrow of With box and select Your required color/background.( here Green text)

7. Click OK.. the numbers will be coloured.

PLEASE MARK AS BRAINLIEAST AND FOLLOW ME