Prev: Data validation
Next: Mysteries on msnews.
From: Jacob Skaria on 25 May 2010 11:10
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
> =A1>75%
>
>
> --
> 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.
First  |  Prev  | 
Pages: 1 2
Prev: Data validation
Next: Mysteries on msnews.