SOLVED

Number Format - Dark Green if Positive and Red if negative

Super Contributor

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.  

 

Tony2021_0-1663951223832.png

 

thank you

 

1 Reply
best response confirmed by Tony2021 (Super Contributor)
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