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

  • Thread starter Thread starter Saz
  • Start date Start date
S

Saz

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
 
Look at conditional formatting in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
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
 
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 said:
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.
Click to expand...
Thank you,
Sajan- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Look at conditional formatting in help.

--
HTH

Bob

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







- Show quoted text -
Click to expand...

Thank your help bob.
 
Hi,

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

Challa Prabhu
 
Back
Top