 |
 | 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 / January 2008Need an IF statement....
I have a worksheet with a list in a column that gives choices .... is it possible to put an if statement somewhere within the sheet to make the choices picked in the column with the list change color? In other words if say in Column C your choices were yes, no, maybe, not at all can you put an if statment in say Column XX that says if the answer in c is yes then the font will show as bold red, if no the bold blue and so on...... format>conditional formatting>etc  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I have a worksheet with a list in a column that gives choices .... > is it possible to put an if statement somewhere within the sheet to [quoted text clipped - 5 lines] > that says if the answer in c is yes then the font will show as bold > red, if no the bold blue and so on...... > format>conditional formatting>etc > [quoted text clipped - 14 lines] > > - Show quoted text - Sorry but I do not understand..... can you be a tad more explicit as to how i wntern this..... much appreciated Have you read a book on Excel? Tyro >I have a worksheet with a list in a column that gives choices .... > is it possible to put an if statement somewhere within the sheet to [quoted text clipped - 5 lines] > that says if the answer in c is yes then the font will show as bold > red, if no the bold blue and so on...... @tyro: have you read a book on manners? @TechnoGram: What you are looking for are the so called "conditional formats" http://www.mvps.org/dmcritchie/excel/condfmt.htm (Maybe this tutorial is a little bit too much, otherwise look it up in google) Oh...and please don't forget to post your version of Excel the next time. hth Carlo > Have you read a book on Excel? > [quoted text clipped - 9 lines] > > - Show quoted text - > @tyro: have you read a book on manners? > [quoted text clipped - 27 lines] > > - Show quoted text - Thanks I am sure I will be able to go through the examples and understand it..... as to versions well at present I work on 3 .... 2002, 2003 and 2007....... As always there are many on this group that are extremely helpful in pointing one in the right direction...... |
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.