VBA Excel 2000 - Basic colors handling
Posted on 2011-02-15
Could you propose a reliable way of using VBA commands about font coloring?
I am aware two versions for example to blue
Worksheets("Sheet1").Range("A1").Font.ColorIndex = 6 - this using the place of color from pallet
Worksheets("Sheet1").Range("A1").Font.Color = 16711680 - this would set the blue color, but as I perceive at default color pallet settings, it became yellow :-)
Is there maybe chance to use RGB values in VBA?