 |
 | 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 / June 2004Color in Cells
I have a spreadsheet that say in B2 i have three different inputs optinons when i put the letter "A" in i want the cell to turn red when i put the letter "B" in i want the cell to turn blue when i put the letter "C" in i want the cell to turn green is there a way to do this automatic?? -- Message posted from http://www.ExcelForum.com format>conditional format>easy from there  SignatureDon Guillett SalesAid Software donaldb@281.com > I have a spreadsheet that > [quoted text clipped - 8 lines] > --- > Message posted from http://www.ExcelForum.com/ i dont understand this ans. please tell me how to do i -- Message posted from http://www.ExcelForum.com it's quite simple. Click one time in a cell with your left mouse button Click once your right button of your mouse once and select with you left button of your mouse with one single click "format....... -- Message posted from http://www.ExcelForum.com Try this http://www.contextures.com/xlCondFormat01.html SignatureFor everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom > i dont understand this ans. > please tell me how to do it > > --- > Message posted from http://www.ExcelForum.com/ i want to have each of the options give me different colors a to = red b to = green c to = yellow all three of these will a option for the same cel -- Message posted from http://www.ExcelForum.com Hi jladika! Select the cell Format > Conditional Formatting Select "Cell Value is" from first drop down Select "Equal to from second drop down Type ="a" in right text box Press Format button Select Pattern Tab Select a red colour OK Press Add button etc. The only difficult bit /common problem is not using ="a" for a text condition. SignatureRegards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au >i want to have each of the options give me different colors > [quoted text clipped - 6 lines] > --- > Message posted from http://www.ExcelForum.com/ Hi jladika! Just in case you thought you would extend one cell to several more cells it would be better to do them all at once rather than one at a time such as with the Format Painter. Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hi jladika! > [quoted text clipped - 23 lines] > > --- > > Message posted from http://www.ExcelForum.com/ thanks i am sorry but i still haveing a problem can you walk me through thi -- Message posted from http://www.ExcelForum.com would you show me an example for please in one cell "A" = red "B"= blue "C"= green "D" = yellow thanks jo -- Message posted from http://www.ExcelForum.com Hi Joe, You were supplied a solution, but this would be my solution. Suggest reading: http://www.mvps.org/dmcritchie/excel/condfmt.htm Select the column(s) you want the change to affect the coloration. If you want rows to be colored then use Ctrl+A You can select a cell before using Ctrl+A. The formula you use is based on the active cell, the cells that get colored are based on your selection, so if Cell A1 is active you might code format, conditional formatting C.F formula 1: =$A1="a" C.F formula 2: =$A1="b" C.F formula 3: =$A1="c" when you enter each formula, you click on the format in the middle, and make choices on Font and or Patterns (tabs). These Worksheet formulas are not case sensitive. If you have more than 3 colors you will have to use and Event Macro. http://www.mvps.org/dmcritchie/excel/event.htm#case --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > would you show me an example for > [quoted text clipped - 3 lines] > "D" = yellow > thanks joe can you have more then 3 options per cell? --- Message posted from http://www.ExcelForum.com/ Hi Jladika! Conditional formatting is limited to three conditions. However you do have the default format that applies where no condition is satisfied. You also have the possibility of different formats for (usually) positive, negative and zero. But in most cases where you need more than three formats for your conditions, you will need to resort to VBA. For this, David McRitchie has already referred you to: http://www.mvps.org/dmcritchie/excel/event.htm#case However, if you are doing this for mainly presentation purposes, my own view is that you should try to avoid too many different colours. SignatureRegards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Right click on the sheet tab>view code>copy/paste this.Adapt the letters and color numbers to your needs. As written, it works on column A (1). Again, change to suit. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 1 Then Exit Sub Target.Interior.ColorIndex = 0 If UCase(Target) = "U" Then _ Target.Interior.ColorIndex = 5 If UCase(Target) = "D" Then _ Target.Interior.ColorIndex = 7 End Sub SignatureDon Guillett SalesAid Software donaldb@281.com > can you have more then 3 options per cell? > > --- > Message posted from http://www.ExcelForum.com/ can someone help me out when i get send a forumla like this vLetter=Ucase(left(cell.value&"",1)) can someone break it done so i can understand it like give me an example. thank -- Message posted from http://www.ExcelForum.com I expect you left out a space between the double quotes. Event Macros, Worksheet Events and Workbook Events http://www.mvps.org/dmcritchie/excel/event.htm#case LEFT in VBA works almost the same as LEFT in Excel it takes the leftmost characters, the " " in the concatenation guarantees something will be there even if it is a space. Concatenation (adds to the end of) varA = "abc " varB = "def" varC = varA & varB gets same value as varC = "abc def" UCase in VBA works the same as UPPER in Excel it converts the character to uppercase. Most of the things with Excel Worksheet Functions are not case sensitive. Most of the things in VBA are case sensitive. So we will want be later comparing capital letter to a capital letter in the macro with Select Case. http://www.mvps.org/dmcritchie/excel/strings.htm#sensitivity --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > can someone help me out > when i get send a forumla like this [quoted text clipped - 6 lines] > --- > Message posted from http://www.ExcelForum.com/ thanks to all that helped me with this i got it thanks agai -- Message posted from http://www.ExcelForum.com |
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.