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.