=?Utf-8?Q?Formatting_cells_Auto_fill_color?==?Utf-8?Q?_using_=E2=80=9CIf=E2=80=9D?=

[Masatami]

I have the following formula in a cell:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","GREEN")))
I am attempting to change the color of Green to Bright Green. I assumed
changing the formula to:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","BRIGHTGREEN")))
would work but in changing the formula resulted in a Black filled cell not
bright green.

If some one could advise how to change to a different color it would be
appreciated.

[Dave R.]

Where to begin...

WIth reference to your first formula, that formula will return "BLACK" for
any value less than 1 (that is, <1).. any number more than 1 and you'll get
"GREEN" or "Brightgreen".. you either have the signs or the order mixed up.

You cannot change colors like that. If you want to change colors, see
conditional formatting under online help (F1).




"Masatami" <Masatami @discussions.microsoft.com> wrote in message
news:[email protected]...
> I have the following formula in a cell:
> =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","GREEN")))
> I am attempting to change the color of Green to Bright Green. I assumed
> changing the formula to:
> =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","BRIGHTGREEN")))
> would work but in changing the formula resulted in a Black filled cell not
> bright green.
>
> If some one could advise how to change to a different color it would be
> appreciated.
>

[Masatami]

Dave,

Thank you for pointing me in the correct direction your time is appreciated.

"Dave R." wrote:

> Where to begin...
>
> WIth reference to your first formula, that formula will return "BLACK" for
> any value less than 1 (that is, <1).. any number more than 1 and you'll get
> "GREEN" or "Brightgreen".. you either have the signs or the order mixed up.
>
> You cannot change colors like that. If you want to change colors, see
> conditional formatting under online help (F1).
>
>
>
>
> "Masatami" <Masatami @discussions.microsoft.com> wrote in message
> news:[email protected]...
> > I have the following formula in a cell:
> > =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","GREEN")))
> > I am attempting to change the color of Green to Bright Green. I assumed
> > changing the formula to:
> > =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","BRIGHTGREEN")))
> > would work but in changing the formula resulted in a Black filled cell not
> > bright green.
> >
> > If some one could advise how to change to a different color it would be
> > appreciated.
> >
>
>
>

[Dave R.]

It was my pleasure sir.


"Masatami" <[email protected]> wrote in message
news:[email protected]...
> Dave,
>
> Thank you for pointing me in the correct direction your time is
appreciated.
>
> "Dave R." wrote:
>
> > Where to begin...
> >
> > WIth reference to your first formula, that formula will return "BLACK"
for
> > any value less than 1 (that is, <1).. any number more than 1 and you'll
get
> > "GREEN" or "Brightgreen".. you either have the signs or the order mixed
up.
> >
> > You cannot change colors like that. If you want to change colors, see
> > conditional formatting under online help (F1).
> >
> >
> >
> >
> > "Masatami" <Masatami @discussions.microsoft.com> wrote in message
> > news:[email protected]...
> > > I have the following formula in a cell:
> > > =IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","GREEN")))
> > > I am attempting to change the color of Green to Bright Green. I
assumed
> > > changing the formula to:
> > >
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","BRIGHTGREEN")))
> > > would work but in changing the formula resulted in a Black filled cell
not
> > > bright green.
> > >
> > > If some one could advise how to change to a different color it would
be
> > > appreciated.
> > >
> >
> >
> >

[Gord Dibben]

Masatami

Are you saying that with that formula the cell background color actually
changes to red or black or green or yellow?

How do you do that?


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 14:09:02 -0800, "Masatami" <Masatami
@discussions.microsoft.com> wrote:

>I have the following formula in a cell:
>=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","GREEN")))
>I am attempting to change the color of Green to Bright Green. I assumed
>changing the formula to:
>=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"YELLOW","BRIGHTGREEN")))
>would work but in changing the formula resulted in a Black filled cell not
>bright green.
>
>If some one could advise how to change to a different color it would be
>appreciated.