Hi,

I want to selectively copy conditional formatting (not normal formatting)
from one cell to another. (Paste special wont work)

a) Has anybody ever felt this need?

b) Can it be done without a macro?

Thanks a lot,
Hari
India

Hi,

we can set conditional formatting in cell range at a time.
assuming copy from A1 to A3:A10,
select A3:A10, delete conditional formatting if it exists,
ctrl+click A1 and set conditional formatting.

--
HTH,

okaizawa


Hari Prasadh wrote:
Hi,

I want to selectively copy conditional formatting (not normal formatting)
from one cell to another. (Paste special wont work)

a) Has anybody ever felt this need?

b) Can it be done without a macro?

Thanks a lot,
Hari
India