2

Please use the following formula =B2>=A2 for green (if the cell on the right is greater than or equal to the cell on the left) =AND(B2>=A2,B2<>"") =B2<A2 for red (if the cell on the right is less than the cell on the left) =AND(B2<A2,B2<>"")


2

Either the Apply to range or the formulas are wrong. Instead of B:B use B2:B OR Instead of B2>=A2 it should be B1>=A1 Instead of B2<A2 it should be B1>A1 Apply to range you might select the whole column B Use a custom formula with relative references i.e. B1 instead or $B$1 First rule Second rule Related How to conditional format in ...


Only top voted, non community-wiki answers of a minimum length are eligible