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 Dark Green and Color5 but those names dont seem to be in the list of available colors.
thank you
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)
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
