Printing cells with conditional formats & formulas
 

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?

Printing cells with conditional formats & formulas
 

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?

Printing cells with conditional formats & formulas
 

For documentation purposes, you would not know which of the
three conditions was in effect so you would have to show all three
if three exist. Excel 12 should be more fun for you.

Perhaps your documentation should concentrate on representative
formulas, how they work, when they are used.

If you really want to show which specific formula was used you
could take a look at my Excel to HTML conversion, and I guess
the suggestion to put the formula into the comment would be
workable. I expect you would have a very large workbook.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"macropod" wrote in message ...
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?