Cell colour change automatically

Is it possible to create a formula to automatically turn a cell a given colour?
Example: -
If I type the word "Yes" in a cell I would like the cell to turn red
automatically,
If I type the word "No" in a cell I would like the cell to turn green
automatically.
Is this possible?
If yes please recreate a formula to assist me.
Many thanks -=- dustyv

Take a look at "Conditional Formatting" in XL Help.

In article <45794F52-0D61-4B8F-8562-A3E9E6F957BE@microsoft.com>,
dustyv <dustyv@discussions.microsoft.com> wrote:

> Is it possible to create a formula to automatically turn a cell a given
> colour?
> Example: -
> If I type the word "Yes" in a cell I would like the cell to turn red
> automatically,
> If I type the word "No" in a cell I would like the cell to turn green
> automatically.
> Is this possible?
> If yes please recreate a formula to assist me.
> Many thanks -=- dustyv

Hi

this can be achieved via conditional formatting
select the cell(s) that you want to go green or red
choose format / conditional formatting
choose
value is
equal to
type
no
click format - choose green - ok
choose ADD
choose
value is
type
yes
click format - choose red - ok twice

Hope this helps
Cheers
JulieD

"dustyv" <dustyv@discussions.microsoft.com> wrote in message
news:45794F52-0D61-4B8F-8562-A3E9E6F957BE@microsoft.com...
> Is it possible to create a formula to automatically turn a cell a given
> colour?
> Example: -
> If I type the word "Yes" in a cell I would like the cell to turn red
> automatically,
> If I type the word "No" in a cell I would like the cell to turn green
> automatically.
> Is this possible?
> If yes please recreate a formula to assist me.
> Many thanks -=- dustyv

Thank to both of you for your advice - it works OK with the colour of the
typed word
Is there a method to do the same with the background colour of the cell?
Thanks again

"dustyv" wrote:

> Is it possible to create a formula to automatically turn a cell a given colour?
> Example: -
> If I type the word "Yes" in a cell I would like the cell to turn red
> automatically,
> If I type the word "No" in a cell I would like the cell to turn green
> automatically.
> Is this possible?
> If yes please recreate a formula to assist me.
> Many thanks -=- dustyv

Look up Conditional Formatting in XL Help. Background colors are set
using the Patterns tab of the CF dialog.


In article <0FDA73F7-0779-4A69-92A0-18A5E0B307A1@microsoft.com>,
dustyv <dustyv@discussions.microsoft.com> wrote:

> Is there a method to do the same with the background colour of the cell?

keep in mind that conditional formatting is limited to three conditions.