Changing Background Color in "IF" statement

Greetings,

Is there a way to color cell background from within an "IF" statement ?

Thanks,

-Paul

Hi
not with a formula. But use 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany


Paul Pruchnik wrote:
> Greetings,
>
> Is there a way to color cell background from within an "IF" statement
> ?
>
> Thanks,
>
> -Paul

Paul

Not without using Conditional Formatting or VBA.

Formulas alone cannot change cell formats.

You can place an "IF" statement in CF "formula is"

Or perhaps just a "cell value is" in CF would suffice.

Gord Dibben Excel MVP

On Mon, 25 Oct 2004 13:59:45 -0400, "Paul Pruchnik" <prpruchnik@yahoo.com>
wrote:

>Greetings,
>
>Is there a way to color cell background from within an "IF" statement ?
>
>Thanks,
>
>-Paul
>

Hi Paul,
For help with Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

The great part is that the formulas are Worksheet Function
formulas written to provide either True (not zero), or False (zero)
as the result.

You are limited to 3 colors (+ default), so if you need more
you would need to use an Event macro all described or
linked from the above web page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Paul Pruchnik" <prpruchnik@yahoo.com> wrote in message
> Is there a way to color cell background from within an "IF" statement ?