Sep 23 2022 09:43 AM
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
Sep 23 2022 10:27 AM - edited Sep 23 2022 10:30 AM
SolutionHi,
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
Sep 23 2022 10:27 AM - edited Sep 23 2022 10:30 AM
SolutionHi,
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