Conditional Formating in Google Sheets

by zeeple   Last Updated April 07, 2018 20:03 PM

I am trying to change the color of a cell using conditional formatting in Google Sheets using the following formula:

=IF(B4<=B1, (IF(C4<=C1, (IF(D4<=D1, (IF(E4<=E1, ))) ))))

Pseudo code would be long the lines of:

IF B4 is less than or equal to B1, 
AND C4 is less than or equal to C1,
AND D4 is less than or equal to D1,
AND E4 is less than or equal to E1,
THEN change the color of the cell

However, this does not seem to be working. Any pointers?



Related Questions



Conditional If Formatting Based on Two Columns

Updated February 04, 2018 22:03 PM

How to use AND in Google Sheets w multiple criteria

Updated March 12, 2018 20:03 PM