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/