I’m trying to color a cell in column I based on the value of column D AND column I.
These are the only combinations that are allowed to be entered:

“T0” in column D & “1” in column I

“T1” in column D & “0” in column I

So far, I got the first combination done. So anything else besides T0 in column D and 1 in column I will get colored with this formula:

=NOT(AND($D$4="T0";$I$4=1))

Does anyone know how to add the ‘OR’ function to this formula to ensure that the second combination also doesn’t color?

Thanks a lot!