Hi John,

You could use the vba FormatCondition Object to iterate through all the
conditional formatting parameters for each cell and add any found ones to
the cell's comment box, which you could then display and print out. Not
exactly simple, but it might be worth the effort if there's a lot to do.

Cheers


"John R." <John wrote in message
...
For audit purposes, I must document the cells in a worksheet that have
conditional formatting on them along with their respective formulas. I
have
been unable to find a simple way within Excel and have now resorted to
printing a hardcopy of my worksheet and using a highlighter to flag the
cells
and then handwriting the formulas next to the hightlighted cell. Is
there a
better way?