PC Review


Reply
Thread Tools Rate Thread

conditional formatting - copying columns

 
 
New Member
Join Date: Jun 2008
Posts: 3
 
      12th Jun 2008
Hoping someone mightbe able to help!

I have conditionally formatted a cell and have managed to copy this down the column, so that each cell (eg B1, B2, B3), relates to the revelant row (eg A1, A2, A3).

Now what I want to do is have columns C and D also relate to column A. What seems to be happening is column C relates to column B instead.

I hope this makes sense, and I hope someone can help, as this has been bugging me for days!!

Many thanks in advance

Amanda
 
Reply With Quote
 
 
 
 
Senior Member
Join Date: Feb 2006
Posts: 146
 
      13th Jun 2008
I suspect your formula is copying relative, that is when you copy to C the next column to the left is B so it relates to B.

You need to make the reference to A absolute by prefixing it with $ so when refering to A1 etc you make it $A1 etc. Then when you copy the formula to C and D it will still refer to A.
 
Reply With Quote
 
New Member
Join Date: Jun 2008
Posts: 3
 
      13th Jun 2008
Many many thanks for that. I have just tried it and it works a treat. What a lifesaver!

Thanks again

Amanda
 
Reply With Quote
 
New Member
Join Date: Jun 2008
Posts: 3
 
      13th Jun 2008
another query though!!!! Is there a way to lock the conditional format when copying the sheet onto another workbook. When I do this the precedence of the CF changes and where I put blanks to be the first precedence, it changes them so some of the cells are highlighted when blank.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Conditional formatting gibbylynn Microsoft Excel Misc 2 25th Jan 2010 05:09 PM
Copying conditional format across columns Porky79 Microsoft Excel Misc 1 24th Apr 2009 08:28 PM
Copying conditional formatting...HELP PLEASE!!!! =?Utf-8?B?dHJpeGllYm1l?= Microsoft Excel Worksheet Functions 3 24th Mar 2005 01:53 PM
Copying Conditional Formatting =?Utf-8?B?U01hYw==?= Microsoft Excel Misc 3 11th Mar 2005 07:28 PM
Re: Problems using conditional formatting/copying formatting Norman Harker Microsoft Excel Worksheet Functions 0 5th Aug 2003 09:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:36 AM.