 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007How 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 Look at conditional formatting in help.  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > 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 [quoted text clipped - 3 lines] > Thank you, > Sajan > Look at conditional formatting in help. > [quoted text clipped - 14 lines] > > - Show quoted text - Thank your help bob. 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 SignatureRegards, Peo Sjoblom > 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 [quoted text clipped - 3 lines] > Thank you, > Sajan 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 > 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 [quoted text clipped - 3 lines] > Thank you, > Sajan On Aug 13, 8:54 am, Ron Coderre <RonCode...@discussions.microsoft.com> wrote: > Try this: > [quoted text clipped - 29 lines] > > - Show quoted text - Hi, Refer to topic - "Add, change, or remove conditional formats"-in the online help of the Microsoft Excel 2003. Challa Prabhu > 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 [quoted text clipped - 3 lines] > Thank you, > Sajan
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.