formulas in conditional formatting for 2007
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) |
formulas in conditional formatting for 2007
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) |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com