Color Coding variable Pivot Row Label Interior
Closed
BwanaBill
Posts
2
Registration date
Sunday February 22, 2015
Status
Member
Last seen
March 5, 2015
-
Feb 23, 2015 at 04:12 PM
BwanaBill Posts 2 Registration date Sunday February 22, 2015 Status Member Last seen March 5, 2015 - Mar 5, 2015 at 06:30 PM
BwanaBill Posts 2 Registration date Sunday February 22, 2015 Status Member Last seen March 5, 2015 - Mar 5, 2015 at 06:30 PM
Related:
- Color Coding variable Pivot Row Label Interior
- Rg45 color coding - Guide
- Sound card color code - Guide
- Saints row 2 cheats - Guide
- Notepad++ background color - Guide
- Hard disk diagram with label - Guide
1 response
BwanaBill
Posts
2
Registration date
Sunday February 22, 2015
Status
Member
Last seen
March 5, 2015
Mar 5, 2015 at 06:30 PM
Mar 5, 2015 at 06:30 PM
I found a clunky way of getting round this particular problem!
This code works, but I am sure there is a better way.
I would really appreciate some learned input from you experts out there!
This code works, but I am sure there is a better way.
I would really appreciate some learned input from you experts out there!
' 'Apply Colours to Row Labels
Range("E5").Select
Range(Selection, Selection.End(xlToRight)).Select
Dim myRng As Range
Set myRng = Selection
Dim cell As Object
For Each cell In myRng
Select Case cell.Value
Case Is = "B50", "B60", "B70", "B30", "B90"
cell.Interior.Color = 5296274
Case Is = "BMO", "BO1", "BO2", "MGR"
cell.Interior.Color = 5296274
' Case Is = "B61", "B65", "B71", "B15", "B31", "B48"
' cell.Interior.Color = 10498160
Case Is = "Grand Total"
cell.Interior.Color = xlNone
Case Else
cell.Interior.Color = 65535
End Select
Next