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