Search code examples
if-statementgoogle-sheetsbooleangoogle-sheets-formulaconditional-formatting

Why are some cells not formatting correctly?

I have a google sheet, I apply conditional formatting rules to each row, and the first column appears to be formatting correctly, but the rest of the columns seem to not be. enter image description here

Look at I6 for example, it should be green because it's less than B6, but it's red.

Solution

  • use "custom formula" and use:

    =D6=$B6

    on range D6:O

    for red use:

    =D6<>$B6