If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting
I want to copy conditional formatting from one row to a complete table.
However I cant seem to copy the format such that each row has its own unique conditions. I have tried to copy and paste, tried Format Painter with no luck - the rows with the copied format all reference back to the original row. What am I doing wrong? Am using Excel 2003 Thanks |
#2
|
|||
|
|||
Conditional Formatting
You are probably using absolute references like $A$1
Change to relative like A1 Or post an few examples of the method you are using for CF Gord Dibben MS Excel MVP On Mon, 22 Jun 2009 16:44:01 -0700, Jono62 wrote: I want to copy conditional formatting from one row to a complete table. However I cant seem to copy the format such that each row has its own unique conditions. I have tried to copy and paste, tried Format Painter with no luck - the rows with the copied format all reference back to the original row. What am I doing wrong? Am using Excel 2003 Thanks |
#3
|
|||
|
|||
Conditional Formatting
Yes that did the trick
Thanks "Jono62" wrote: I want to copy conditional formatting from one row to a complete table. However I cant seem to copy the format such that each row has its own unique conditions. I have tried to copy and paste, tried Format Painter with no luck - the rows with the copied format all reference back to the original row. What am I doing wrong? Am using Excel 2003 Thanks |
Thread Tools | |
Display Modes | |
|
|