Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
Using Excel 2003 and am trying to format cells depending on a range of values
e.g. If the value is less than 50.999% then colour the cell red If the value is between 51% and 74.999% then colour the cell orange If the value is more than 75% then colour the cell green I have managed to get the first and third examples to work using conditional formatting (formula is: =B4<0.50999) but can't seem to get it to work if the value is between two specific values. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count values in a range of cells depending on value in adjacent ce | Excel Worksheet Functions | |||
How do I reference a range of cells depending on another cell valu | Excel Discussion (Misc queries) | |||
Scores of a Range Cells. Highest or lowest depending a parameter | Excel Worksheet Functions | |||
Reference range of cells and perform subtraction or nothing depending on contents | Excel Worksheet Functions | |||
Change decimal format of cells depending on conditions? | Excel Worksheet Functions |