conditional formatting

[foamcows]

does anyone know if you can conditionally format an object, or more specifically one of the 3d boxes in the drawing tab. I am using office 2007. Thanks for the help.

[Paul]

I don't believe you can conditionally format an object through the Conditional Format dialog window, however, you should be able to do so using VBA code and the worksheet's Change event.