color of a cell within a nested if function

is there a way to assign the color of a cell based on the value of another
cell within a nested if function?

eg something like this formula in cell D350:

IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of
cell N365))

i thinking some kind of conditional formatting maybe?

thanks
Ian

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ian" <Ian@discussions.microsoft.com> wrote in message
news:773D47B1-CF41-4D31-B2C9-15202856847D@microsoft.com...
> is there a way to assign the color of a cell based on the value of another
> cell within a nested if function?
>
> eg something like this formula in cell D350:
>
> IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of
> cell N365))
>
> i thinking some kind of conditional formatting maybe?
>
> thanks
> Ian
>

You need conditional formatting for this. Look up
'Highlight cells that meet specific conditions' in the Answer wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ian" <Ian@discussions.microsoft.com> wrote in message
news:773D47B1-CF41-4D31-B2C9-15202856847D@microsoft.com...
> is there a way to assign the color of a cell based on the value of another
> cell within a nested if function?
>
> eg something like this formula in cell D350:
>
> IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of
> cell N365))
>
> i thinking some kind of conditional formatting maybe?
>
> thanks
> Ian
>