RGB Colors in Format Code for Format Property in Query Column
It would be nice to have more choices than the named colors (Black, Blue, Green, Cyan, Red, Magenta, Yellow, White) in the format code for the Format property of a column in a query.
For instance, we can do this:
[Blue]$ #,##0.00;[Red]$ #,##0.00;-0-
so that positive numbers are blue, negative numbers are red, and zero is black ... but most of the named colors are too bright to show up well.
It would be nice if we could specify an RGB value instead of only the limited color names.
A bonus would be for the Format FUNCTION to also pay attention to color. This would be handy in columns of a combo box or listbox.
thank you
