Why are some cells not formatting correctly?

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

Solution 1:

use "custom formula" and use:

=D6=$B6

on range D6:O

for red use:

=D6<>$B6

Related

Optimizing away static variable / passing by reference
DinkToPdf Net Core not able to load DLL files
Filter by two conditions + Array Formula alternative in google sheets
Reading custom (.ndev) Json-like file structure
Log4j2 - Unrecognized conversion specifier [xwEx] starting at position 160 in conversion pattern
What is a simple way to check if two words overlap at all in Python using indices
Data comes back from API fine but specific fields still undefined
If $f(0) = 0$ and $|f'(x)|\leq |f(x)|$ for all $x\in\mathbb{R}$ then $f\equiv 0$ [duplicate]
Challenging inequality: $abcde=1$, show that $\frac{1}{a}+\frac{1}{b}+\frac{1}{c}+\frac{1}{d}+\frac{1}{e}+\frac{33}{2(a+b+c+d+e)}\ge{\frac{{83}}{10}}$
Calculate minimal polynomial of a matrix
What is a good book for math students to learn machine learning in depth?
Evaluate $\iiint_{[0,1]^3}\frac{dx\,dy\,dz}{(1+x^2+y^2+z^2)^2}$