Why are some cells not formatting correctly?

user_7582941 0
Viewed 26

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.

conditional-formatting google-sheets-formula google-sheets if-statement boolean
1 Answers

use "custom formula" and use:

=D6=$B6

on range D6:O

for red use:

=D6<>$B6
user_56326290
Related