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

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

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TUNGANA KURMA RAJU" wrote:
I am looking for a code that gives a list of conditional formats used in
current sheet,
with cell address,cond.format formula,formats.