Forum Discussion
Solved
Number Format - Dark Green if Positive and Red if negative
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 ...
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
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)
