copy conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Characters 2
Need help with conditions Liz 2
Looping through permutations 7
Excel functions 0
Excel Add ^ to a row of cells containing letters 3
Conditional Format - using 3 different cells conditions together 4
Excel 2003 Conditional formatting not behaving as expected 0
Using icon sets with relative references 0

Back
Top