Forum Discussion
Conditional Formatting Help Please!
Thanks Sergei but it doesn't seem to be quite what I need (unless I am doing something wrong). If you see the below, column A is what I need formatting - red if it is higher than column D, green if it is equal to or less than column C - this is sorted. What I am struggling with is if column A is closer to column C than to column D, but not exactly between, I want it to colour green but if it is closer to, or exactly between, column D than column C, then I want it to colour yellow. So below A2 should colour green as it is closer to column C and A6 should colour yellow as it is exactly between column C & D. Hopefully some visuals make it easier to understand!
Oh, it was hard to make such guess.
For the green the formula could be
=$A2<($C2+$D2)/2
since below C it's also green, and for yellow
=($A2>=($C2+$D2)/2)*($A2<=$D2)
Thank you so much Sergei, perfect!!
You are welcome