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
|