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?