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".
1 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.
