In Excel, you can use two types of cell references:
Relative – A cell reference that adjusts itself when the cell is copied or filled. =A2*B2
Absolute – A cell reference that doesn’t change when copied or filled. =$A$2*B2
Overview of formulas in Excel:
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to apply format rules to.
- Click Format Conditional formatting. A toolbar will open to the right.
- Create a rule.
- Single color: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met.
- Color scale: Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow .
- Click Done.