View Single Post
 
Old 09-19-2014, 08:36 AM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,427
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

I did what I did just to show you that if you isolate the code for evaluating and changing cell shading that it does work. I asked you to run the code I posted in a new document.

That code
1. Created a table
2. Shaded some of the cells with a certain color
3. Then called a function and passed the activedocument as an argument
4. The function evaluated each cell and if the cell shading match that applied in step 2, it changed it to a new color.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote