list of conditional faormats

[TUNGANA KURMA RAJU]

I am looking for a code that gives a list of conditional formats used in
current sheet,
with cell address,cond.format formula,formats.

 

[Scott]

You'll probably have to write yourself a macro.

As a start, you can probably record a macro to see what the command is
to select all the cells that have conditional formatting. (The key
strokes are Ctrl+G, Choose Special, Choose Conditional Formats, hit
OK.)

Scott

 

[Max]

Try Debra's page at:
http://www.contextures.com/xlCondFormat04.html
Excel -- Conditional Formatting -- Documentation
(Code by J.E. McGimpsey)

There's also a sample file for d/l on the page