![]()
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Set I = Intersect(Target, Range("B2:B8"))Ĭase 0 To 100: NewColor = 37 ' light blueĬase 201 To 300: NewColor = 12 ' dark yellowĬase 601 To 1000: NewColor = 20 ' lighter blue Private Sub Worksheet_Change(ByVal Target As Range) The second formula will show u Interior color nr index just time it and when u format the cell with a color it will show nr in the cell Set I = Intersect(Target, Range("B2:B8")) <- thatch the rage u want to work with just set it up for range of cell u want to use to format In this case the condition = case like in example if u want to format something between of the range 0 to 100 for a color #Openoffice calc conditional formatting more than 3 codeHello you also can use this code to force ur worksheet to run with more then on condition. Needless to say it "wowed" many people who only saw Excel as a tool for managing numbers and table based reportsīeing excel just about any user could maintain spreadsheet. no custom software), easy to understand way to manage product from individual machine to groups / classes of product and made it very easy to see how products were performing in geographic relation to each other (something that tables & graphs can't easily do) It took a while to put together, but once in use was rolled out to four casinos and used for 4 years. Users could switch between metrics and repaint the the floor. I used the same concepts to build a heatmap of a casino gaming floor, with each populated cell representing a gaming machine (Slot Machine), some simple metric bucketing to determine different shades for the cells, user selectable colours, ability to pick a 'machine' (click on a cell) and repaint the 'floor' showing only machines with similar charateristics, select a value range and repaint the 'floor' showing only the 'machines' within the value range. Seeing as no one has posted what they actually might use something like this for here's my 2cents What would you use this trick for? A giant heat map, project plan … ?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |