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?
Best Answer
Conditional formatting formulas should return TRUE or FALSE.
NOTE: 0 is coerced as FALSE while other number values as TRUE
For the rule that is expressed in the question you could use AND