For cell H2, use CF/ formula is =if(h2<I2*.5) and copy the format down.
--
David Biddulph

"jbrower" wrote in message
...
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)