Question

Using Conditional Formatting , colour all the cells which have PM2.5 more than 100,green.

Answer 1

Explanation:

Highlight Cells Using Conditional Formatting Based on Another Cell Value in Google Sheets

Select the cells that have the names (A2:A11).

Go to the Format Tab.

Click on Conditional Formatting.

In the Conditional Formatting rules pane, select Single Color.

From the 'Format Cells if' drop down, select 'Custom Formula is'.