Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy conditional formatting
1. I want to copy the conditional formatting set to cell A1 to Cell B1, C1,
D1..K1.How can I do so? Ajit |
#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! -- 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 |
#3
|
|||
|
|||
You could use the Format Painter.
This is the paintbrush Icon on the formatting toolbar. OR select A1 then the other cells and FormatCFOK 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |