Color Palette For Excel 2007

[jstevens]

Is it possible to reset the color palette in Excel 2007? The color scheme from Excel 2003 workbooks are not displaying the true colors.

Example:
ActiveCell.offset(0,0).Interior.ColorIndex = 3

Should be returning red. It is a different color in Excel 2007. I believe the color palette needs to be reset within the workbook.

Thanks,
John

[Jezza]

As you have discovered the color indexing is different however you can use the following function to change the values

Code: Select all

Sub changepalette
    dim colorIndex as long
    colorIndex = 3
    ActiveWorkbook.Colors(colorIndex) = RGB(255, 0, 0)
End sub

You can adapt the code to suit your needs but the refence of the colours versus the code value is attached below

[Sundog]

Example:
ActiveCell.offset(0,0).Interior.ColorIndex = 3

Should be returning red. It is a different color in Excel 2007.

John, on my Excel 2007 SP2, it sure looks Red to me:

red.JPG

[jstevens]

Sundog,

I believe the color palette is unique to each workbook. In a new workbook a colorindex = 3 is indeed red. It would appear that the color palette needs to be reset to the default.

Regards,
John

[jstevens]

Jerry,

I got it to work with your suggestion.

Thank you,
John

[Sundog]

It would appear that the color palette needs to be reset to the default.

How does the color palette get changed in the first place (and/or reset to the default)?

[sdckapr]

Jerry,

I think the bottom left 38 should be 39. Your chart has 2 indices with a value of 38...

Steve

[Jezza]

Jerry,

I think the bottom left 38 should be 39. Your chart has 2 indices with a value of 38...

Steve

Thanks Steve
All changed