Interior.ColorIndex = 31Ĭase "LT TEAL", "lt teal". Interior.ColorIndex = 46Ĭase "TEAL", "teal". Interior.ColorIndex = 45Ĭase "LT ORANGE", "lt orange". Interior.ColorIndex = 15Ĭase "DK ORANGE", "dk orange". Interior.ColorIndex = 56Ĭase "LT GRAY", "lt gray". Interior.ColorIndex = 16Ĭase "DK GRAY", "dk gray". Interior.ColorIndex = 25Ĭase "GRAY", "gray". Interior.ColorIndex = 34Ĭase "DK BLUE", "dk blue". Interior.ColorIndex = 43Ĭase "LT BLUE", "lt blue". Interior.ColorIndex = 51Ĭase "LT GREEN", "lt green". Interior.ColorIndex = 52Ĭase "DK GREEN", "dk green".
Interior.ColorIndex = 53Ĭase "DK BROWN", "dk brown". Interior.ColorIndex = 53Ĭase "LT BROWN", "lt brown". Interior.ColorIndex = 12Ĭase "BROWN", "brown". Interior.ColorIndex = 19Ĭase "DK TAN", "dk tan". Interior.ColorIndex = 36Ĭase "LT TAN", "lt tan". Interior.ColorIndex = 54Ĭase "LT YELLOW", "lt yellow". Interior.ColorIndex = 22Ĭase "DK PINK", "dk pink". Interior.ColorIndex = 26Ĭase "LT PINK", "lt pink". Interior.ColorIndex = 22Ĭase "PINK", "pink". Interior.ColorIndex = 30Ĭase "LT RED", "lt red". Interior.ColorIndex = 3Ĭase "DK RED", "dk red". Interior.ColorIndex = 29Ĭase "RED", "red". Interior.ColorIndex = 39Ĭase "DK VIOLET", "dk violet". Interior.ColorIndex = 40Ĭase "LT VIOLET", "lt violet". Interior.ColorIndex = 3Ĭase "TAN", "tan". Interior.ColorIndex = 51Ĭase "PANTONE GREEN", "pantone green". Interior.ColorIndex = 3Ĭase "GREEN", "green". Interior.ColorIndex = 32Ĭase "CYAN GREEN", "cyan green". Interior.ColorIndex = 32Ĭase "CYAN BLUE", "cyan blue". Interior.ColorIndex = 32Ĭase "BLUE", "blue". Interior.ColorIndex = 32Ĭase "PRO BLUE", "pro blue". Interior.ColorIndex = 25Ĭase "PROCESS BLUE", "process blue". Interior.ColorIndex = 21Ĭase "REFLEX", "reflex". Interior.ColorIndex = 21Ĭase "VIOLET", "violet". Interior.ColorIndex = 39Ĭase "DK PURPLE", "dk purple". Interior.ColorIndex = 29Ĭase "LT PURPLE", "lt purple". Interior.ColorIndex = 26Ĭase "PURPLE", "purple".
/applying-background-colors-to-tables-3539984-af483e91a10145c8b1c098b377c9cb72.gif "two different cell background color word")
Interior.ColorIndex = 3Ĭase "RHODAMINE", "rhodamine". Interior.ColorIndex = 3Ĭase "RUBINE", "rubine". Interior.ColorIndex = 46Ĭase "WARM RED", "warm red". Interior.ColorIndex = 6Ĭase "ORANGE", "orange". If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing ThenĬase "YELLOW", "yellow".
#TWO DIFFERENT CELL BACKGROUND COLOR WORD CODE#
Once match is found the word is changed, or copied into cell "F3" making the change I am looking for, from my sample code bellow:Ĭonst WS_RANGE As String = "B100:B130,Q1" '<= change to suit It would be ideal for me, "if this option could be done automatically by having cell "F3" search, or look up a list of keywords indicated as defaults to find corresponding match from text string in cell "D3". (Such: 500' Roll green wire")Īnd I manually enter the word "green" into cell "F3" in order to make this cell change background color to "green". In cell "D3" I enter the Description of the Item. Just to give you an idea of what I am doing and currently using.īELLOW: YOU WILL SEE THE ACTUAL CODE IN USE NOW
0 kommentar(er)
