Report for Conditionally Formatted Cells
 

Hi There,

Is there anybody who has a routine available that creates a report for
my active sheet / workbook that says on which cells conditional
formatting has been applied. Possibly with the conditions applied for
those cells?

Looking forward,

Sige

Report for Conditionally Formatted Cells
 

Hi,
listing all the format conditions may be a bit complicated, as there
are so many permutations.

This macro will return a simple list of all cells in the active sheet's
used range with conditional formats (note cells outside the usedrange
will not be picked up):

Sub show_conditional_cells()
cczz = ""
n = 0
For Each cc In ActiveSheet.UsedRange.Cells
If cc.FormatConditions.Count 0 Then

cczz = cczz & cc.Address & " "
n = 1 + n

End If
Next
cczz = Trim(cczz)
If cczz = "" Then MsgBox ("no conditional formats on this sheet") Else
MsgBox "there are " & n & " cells with conditional formats on this
sheet: " & cczz

End Sub


--
Nicky


------------------------------------------------------------------------
Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
View this thread: http://www.excelforum.com/showthread...hreadid=380782

Report for Conditionally Formatted Cells
 

Hi Nicky,

Thanks for your code!!!
I will have to find a way to get the conditions for the formatting still
...
Suggestions welcome!

Cheers Sige
"NOSPAM" to be removed for direct mailing...

*** Sent via Developersdex http://www.developersdex.com ***

Report for Conditionally Formatted Cells
 

Good afternoon Sige

There is a utility in John Walkenbachs Power Utility Pak that will d
just this. It costs $40 but you can download an evaluation versio
that will work unrestricted from his site. Once installed go to PUP v
Auditing Tools Conditional Formatting Report.

http://j-walk.com/ss/pup/pup6/index.htm

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=38078