I have set the following conditional format: Cell Value is equal to =$C$3=Q1
in cell C2 and have the cell change color. The conditional format works if C2
is blank but whenever a value is present the color reverts back to the
default. Any suggestions?