i am trying to put in a formula so that if the cell value is less than the
value of the next column times .5 it shades it as well as if the cell value
is that same cell but greater than it times 1.5 but it wont work? any ideas?

i went to using formula and put in
=if(h:h<I:I*.5)
=if(h:hI:I*1.5)