Possible to use RGB or Hex code in number formatting code

[Skysurfer]

Hi,

I am trying to create a custom number format that uses the green in the standard color palette. Specifically, RGB 0, 176, 80 (Hex #00B050). That is the green on the "Standard Colors" row when selecting a cell or font color. The popup bubble calls it "Green".

Problem is, that is NOT the same green if I use custom number format ["Green]+0.0%;[Red]-0.0%". And it's not Color10.

Is this even possible?

Lawrence

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try
[Color10]+0.0%;[Red]-0.0%

 

[Tetra201]

... And it's not Color10...

A workaround: set Color10 in your workbook to whatever you need by running the following code, then use [Color10]+0.0%;[Red]-0.0%

Sub SetColor10()
    ActiveWorkbook.Colors(10) = RGB(0, 176, 80)
End Sub

 

[Skysurfer]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try
[Color10]+0.0%;[Red]-0.0%

View attachment 96850

Thank you. Haven't logged-in in years. Hope I've supported the platform!

 

[Skysurfer]

A workaround: set Color10 in your workbook to whatever you need by running the following code, then use [Color10]+0.0%;[Red]-0.0%

Sub SetColor10()
    ActiveWorkbook.Colors(10) = RGB(0, 176, 80)
End Sub

Cool. Where do you recommend I fire this code? Whenever the worksheet is activated? Or on workbook open?

 

[Tetra201]

It's a run-once code; the color is saved within the workbook. The workbook can be saved as a macro-free one if you have no other code in it.

 

[Skysurfer]

This forum is still the best! Many thanks.