Can basic color palette be changed in conditional formating

[Guest]

I wish to change the back color in response to a condition. However in
conditional formating (CF) it appears I have to use one of the 48 basic
colors. I wish to use a custom color but there is no facility in CF. Does
anyone know of a method of changing the colors in the basic palette?

 

[Stephen Lebans]

You have to programmatically modify the FormatConditions object directly.
Sample code is here:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Problem solved many Thanks

You have to programmatically modify the FormatConditions object directly.
Sample code is here:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.