Google-sheets – Conditional format based on data in 2 columns

Here is what you can do:

1. RightClick B2 → select Conditional formatting → select Custom Formula is (from the List)
2. Enter the following formula in the textbox: =b2>=c2
3. Check the Background Color and select green color
4. Click on Add another rule
5. Select Custom Formula is (from the List)
6. Enter the following formula in the textbox: =b2<c2
7. Check the Background Color and select red color
8. Click on Save Rules
9. Highlight B2 and click on Paint Format option on the tool bar.
10. Now click on cell B3 and drag until cell - B117 (this should apply the conditional formatting on cell ranging from B3-B117)

And for your second condition (i.e., to highlight D with green if it is greater than or equal to E, red if it is less than E) - simply repeat the above steps by interchanging D2 for B2 and E2 for C2.

Apply to a range such as A2:Z the conditional formatting with the custom formula

=and($L2="APPROVED", $M2="APPROVED", $N2="APPROVED", $O2 = "X")

Explanation

• The formula is written as it should be applied to the upper left corner of the range, that is A2 here.
• Dollar signs are used to make column references absolute, so that, for example, formatting of cell B2 would still refer to O2 and not to P2.
• The row references are relative, so that, for example, third row cells refer to L3, M3, N3, and O3.