On Feb 10, 10:18*pm, "Rick Rothstein"
wrote:
You cannot "see" the formatting resulting being applied to a cell from
Conditional Formatting directly. The best you can do is have your code
perform the same test that the Conditional Formatting is doing... if your
test is True then so is the one the Conditional Formatting is evaluating, so
then you know it is applying whatever formatting to the cell that was
specified.

Rick Rothstein (MVP - Excel)


thanks - I had a suspicion the answer was going to be something along
the lines of your response...

Art