xlColorIndexAutomatic (Excel 03)

Topic

New Reply

I want to set the code to reflect a specific color property instead of automatic. I want to use a light gray instead of the black lines, but I don’t know where to go to grab the color. I want to change .ColorIndex = xColorIndexAutomatic to = RGB(?,?,?) Thanks!

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
With Target.TableRange1.Borders
.LineStyle = xlContinuous
.ColorIndex = xlColorIndexAutomatic
.Weight = xlThin
End With
End Sub

Reply | Quote

Replies

Instead of “colorindex” use something like:
.Color = RGB(200,200,200)

Steve

Reply | Quote

This is perfect. Thank you. But another quick question, where can I go to get what the numbers are for each category? See I wouldn’t have know that 200 across would give me the gray color I want. Where could I test the color and identify the numbers I need to use? Thank you again!

Reply | Quote

Navigate to:

Tools | Options | Color (tab) | Modify (button) | Custom (tab)……

You can input your numbers and keep adjusting them until you find what suit’s.

Be careful not to unintentionally over-save your color palette in testing….

Regards
Nathan

Reply | Quote

Cool. I knew I saw it SOMEWHERE. I just couldn’t remember. Thanks all!

Reply | Quote

You can input your numbers and keep adjusting them until you find what suit’s.

Or you can select the color from the graphic and the RGB values will be inputted…

Be careful not to unintentionally over-save your color palette in testing….

If you do you can use the [Reset] button to put back to the default

Steve

Reply | Quote

Hi Christine:

FWIW, since you want grey, you will always get a shade of grey if the RGB values are all the same,

Reply | Quote