Forum Discussion
Need help with a conditional formatting equation
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 this:
Hello Stephen,
I'm having a tricky time getting it to work. I will give a more practical scenario.
In this case, I used IF functions to get cell D1 to subtract B1 from C1 unless the difference is less than A1 in which case, to display A1. If the C1 value was 10, D1 would display 9 but since C1-B1<A1 it is displaying A1. I am trying to get Cell D1 to fill with color if C1-B1<A1 even though cell D1=A1.
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:
