Hi Ajit,

Use the format painter(paint brush icon).
Select the cell that has the desired cond. formatting,
then press the format painter(double click if copying format to 2+ cells),
select the cell(s) that you want the same cond. formatting applied to.

Have a great day!
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"ajitbmunj" wrote:

1. I want to copy the conditional formatting set to cell A1 to Cell B1, C1,
D1..K1.How can I do so?

Ajit