Question

what are the steps to apply green color to number above 100 to a range of cells using conditional formatting ?

Answer 1

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.