Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in 2007 | Excel Discussion (Misc queries) | |||
conditional formatting 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting 2007 | Excel Worksheet Functions | |||
Conditional formatting 2007 | Excel Worksheet Functions | |||
Conditional Formatting and If/Then Formulas | Excel Discussion (Misc queries) |