Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |