|
| 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
June 23rd, 2009, 12:44 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
June 23rd, 2009, 03:44 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
June 23rd, 2009, 04:20 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
