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:
The $C5 and $B5 can be on any sheet, just tried that as well
nice one, as they say every day is a school day!