Forum Discussion
Solved
Need help with a conditional formatting equation
Hello,
I am trying to get a series of cells within a column "D" to fill in with color if the difference between values in two adjacent columns "B & C" is less than a value in a column on anothe...
I seem to have it working like this:
I'm assuming it colours when A=D
I have the formula as:
and the conditional formatting as, but you could equally just select not equal to:
try using an IF statement which returns 1 or 0 (format column as number no dec places) then the formatting should work OK. I just tried the true and false and could not get it to work. I am no expert but this may work for you.