I am tracking high school credit acquisition. Each trimester a student must earn 2 credits to remain on track. If Cell A1 is "trimester 1 total credits", and cell B1 is "trimester 2 total credits", I need a formula to the effect of "B1>=A1+2 then turn GREEN".
Google-sheets – Conditional Formatting Referencing another Cell (and using addition)
conditional formattingformulasgoogle sheets
Related Topic
- Google-sheets – How to change both the contents of a cell and its conditional formatting based on a cell in another column
- Google Sheets – How to Apply Relative Reference in Conditional Formatting
- Google-sheets – How to apply conditional formatting to a Google Sheet to show three checkboxes minimum are checked
- Google Sheets – Combine Custom Formula with Colour Scale in Conditional Formatting
- Google-sheets – Automatic cell coloring via conditional formatting
- Google Sheets – Combine Checkbox and Conditional Formatting
Best Answer
In the formatting dialog, select "custom formula" with the formula
= B1>=A1+2
. That is, enter the inequality or equality you wish to trigger the formatting, preceded by=
sign.