1. I want to copy the conditional formatting set to cell A1 to Cell B1, C1,
D1..K1.How can I do so?
Ajit
1. I want to copy the conditional formatting set to cell A1 to Cell B1, C1,
D1..K1.How can I do so?
Ajit
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
You could use the Format Painter.
This is the paintbrush Icon on the formatting toolbar.
OR select A1 then the other cells and Format>CF>OK
The CF will be carried over to the other cells.
Note: if a formula, make sure you have the references properly set using the $
signs(s)
Gord Dibben Excel MVP
On Thu, 29 Sep 2005 03:44:02 -0700, ajitbmunj
<[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks