Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
conditional formats affect other cells | Excel Discussion (Misc queries) | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |