Number Format - Dark Green if Positive and Red if negative

[Tony2021]

Experts, how can i shade a positive number a darker green than what shows below? 

this is what I am using

[Green]€#,##0.00;[Red](€#,##0.00);[Green]€#,##0.00

I have tried replacing "Green" with Dark Green and Color5 but those names dont seem to be in the list of available colors.  

thank you

[#2 · Accepted solution]

Hi,

In the Format property you are constrained to the 8 available colors:

Black, Blue, Green, Cyan, Red, Magenta, Yellow, White

Whereas in a form you can use the Conditional Formatting feature with a much wider range of colors, even very dark green. 😉

Servus
Karl
Access News
Access DevCon

[#3]

@Tony2021 you can use custom color numbers. For a darker green, use Color 10.

Here is my formatting for SERP rankings, where a lower number is better. (moving from position 10 to 8 is -2 but actually better) [Red]#,##0.000_);[Color10](#,##0.000)