How can I change the color of the cell when someone enter any number or character?
 

Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan

How can I change the color of the cell when someone enter any number or character?
 

Look at conditional formatting in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Saz" wrote in message
ups.com...
Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan

How can I change the color of the cell when someone enter any number or character?
 

Lookup conditional formatting in help, then use it like

cell value equal to "yes", click the format button and select pattern and
green, then click add and cell value equal to "no" and do the same but use
red


--
Regards,

Peo Sjoblom



"Saz" wrote in message
ups.com...
Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan

How can I change the color of the cell when someone enter any numb
 

Try this:

Select the range of input cells

From the Excel main menu:
<format<conditional formatting
Condition_1
Cell value is: equal to: Yes
Click the [format] buttton....set the color....click [OK]

Click the [Add] button
Condition_2
Cell value is: equal to: No
Click the [format] buttton....set the color....click [OK]
Click [OK]

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Saz" wrote:

Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan

How can I change the color of the cell when someone enter any numb
 

On Aug 13, 8:54 am, Ron Coderre
wrote:
Try this:

Select the range of input cells

From the Excel main menu:
<format<conditional formatting
Condition_1
Cell value is: equal to: Yes
Click the [format] buttton....set the color....click [OK]

Click the [Add] button
Condition_2
Cell value is: equal to: No
Click the [format] buttton....set the color....click [OK]
Click [OK]

Does that help?
***********
Regards,
Ron

XL2003, WinXP
Thank you guys for your PRICELESS help...............man this is my first time browsing in this site and I LOVE IT. =)


"Saz" wrote:
Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan- Hide quoted text -

- Show quoted text -

How can I change the color of the cell when someone enter any number or character?
 

On Aug 13, 8:50 am, "Bob Phillips" wrote:
Look at conditional formatting in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Saz" wrote in message

ups.com...



Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan- Hide quoted text -

- Show quoted text -

Thank your help bob.

How can I change the color of the cell when someone enter any numb
 

Hi,

Refer to topic - "Add, change, or remove conditional formats"-in the online
help of the Microsoft Excel 2003.

Challa Prabhu

"Saz" wrote:

Hi... =) I am trying to build a templete with a list of questions
where the users will answer YES or NO. Please help me to change the
color of the cell to Green if they answer yes, and Red if they answer
no.

Thank you,
Sajan