- Open your spreadsheet
- Select the range of cells that you want the formatting applied to (both negative & positive)
- Click Format in the main menu
- Click Conditional Formatting from the drop down menu
- Apply the desired rules in the right hand side block
- Google help article 78413: Use conditional formatting rules in Google Sheets
- G Suite Learning Centre: See data changes with conditional formatting