Forum Discussion
Conditional Formatting Help Please!
Hi, I am trying to set up conditional formatting for when a number is above or below the mid part of a range. E.g. the lower range is 200 and the upper range is 300, if the number I have is 2...
Hi Rich
Thanks for this but maybe I should have been a bit clearer. The upper and lower ranges differ on each row, it might be 200-300 but the next row will be 825-1000, the next row 525-675 etc. I then have a value in another cell and I need to format that cell green if it is closer to the upper range and yellow if it is closer to the lower range
Hope that makes sense
the only way i know of as to how to do this would be to use an extra column & add a formula then use that to do your conditional formatting
ie if column A is you list of numbers have column b as if(a<(half your number),1,0) then have 2 condition formats to work from the 1 or the 0
hope this helps :)
saf