Windows XP conditional formatting - copying columns

[amandasheldrick]

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

 

[SlimJim]

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.

 

[amandasheldrick]

Many many thanks for that. I have just tried it and it works a treat. What a lifesaver!

Thanks again

Amanda

 

[amandasheldrick]

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.