Forum Discussion
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 another worksheet "worksheet 1 column A".
Here is a generic form of what I got:
="$C1-$B1<'worksheet 1'!$A1''
It accepted the equation but the formatting that I want is not working. Any ideas?
7 Replies
- nice one, as they say every day is a school day!
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.
- 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.
