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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
Maybe
=B4<51% for red =AND(B4=51%,B4<75%) for orange =B4=75% for green -- Regards! Stefi €˛gashman€¯ ezt Ć*rta: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
Try it like this...
=AND(cell_reflower_boundary_value,cell_ref<upper_ boundary_value) Or... =AND(cell_ref=lower_boundary_value,cell_ref<=uppe r_boundary_value) -- Biff Microsoft Excel MVP "gashman" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
CF's are evaluated in order. As soon as a conditon is met it stops evaluating
so all you need is Less than 51% Less than 75% Greater than or equal to 75% -- HTH... Jim Thomlinson "gashman" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
Use the below formulas for a selected range say A1:A10 with active cell A1.
=A1<50.999% =MEDIAN(51%,A1,74.999%)=A1 =A175% -- Jacob (MVP - Excel) "gashman" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells depending on value range
Ofcourse the 1st one has to be this way to handle blanks
=AND(A1<"",A1<50.999%) -- Jacob (MVP - Excel) "Jacob Skaria" wrote: Use the below formulas for a selected range say A1:A10 with active cell A1. =A1<50.999% =MEDIAN(51%,A1,74.999%)=A1 =A175% -- Jacob (MVP - Excel) "gashman" wrote: 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. |
Reply |
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 |