Conditional Formatting

J

Jono62

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Conditional formatting 2
Copy Conditional Formatting down rows 5
Conditional formatting in range 1
Conditional fomat series 2
Excel 2007 - A Conditional Formatting ?'s 1
Conditional format lowest value greater than zero and copy formula 2
Excel Conditional Formatting 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Top