G Guest Sep 29, 2005 #1 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
G Guest Sep 29, 2005 #2 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!
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!
G Gord Dibben Sep 29, 2005 #3 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 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
