Conditional Format - Excel 2007
Thread Starter
Join Date: Apr 2005
Location: Bexhill-on-Sea
Age: 77
Posts: 48
Likes: 0
Received 0 Likes
on
0 Posts
Conditional Format - Excel 2007
Apologies if this has been asked before
I'm trying to copy a conditional format from a single cell to a long column with the reference cell changing as the row changes.
eg
the formula for formating is =D182<>E182 and is in D182, when I copy this to other rows, about another 50, the formula doesn't change it remains D183, being the cell I clicked on to start coping, even in cell D190 for example has the formula D183<>E183 .
I've tried copying all the different ways that I know, still the same.
I've got about 10 different columns to format on 12 worksheets.
Hope the above is clear
Any suggestions?
Thanks
Merch
I'm trying to copy a conditional format from a single cell to a long column with the reference cell changing as the row changes.
eg
the formula for formating is =D182<>E182 and is in D182, when I copy this to other rows, about another 50, the formula doesn't change it remains D183, being the cell I clicked on to start coping, even in cell D190 for example has the formula D183<>E183 .
I've tried copying all the different ways that I know, still the same.
I've got about 10 different columns to format on 12 worksheets.
Hope the above is clear
Any suggestions?
Thanks
Merch
Join Date: Jan 2006
Location: UK
Posts: 130
Likes: 0
Received 0 Likes
on
0 Posts
Hi Merch
Your post is a little confusing. You say, for example, that D190 contains D183<>E183.
Does it actually contains =D183<>183? This would return True or False as the cell value. If it contains D183<>E183, without the equals sign, Excel will treat this as text and will copy it verbatim. If the formula is =D183<>E183, then Excel will definitely amend the formula if you copy it to another cell. If there is a dollar sign in front of the column or row, then Excel will fix that value when you copy it. If there is a dollar in front of both the column and row, Excel will copy the formula without modification.
On the other hand, you are asking about conditional formatting. Is the formula =D183<>E183 your condition? Are you trying to apply conditional formatting to a range of cells such that the format for D183 is set by D183<>E183, the format for D184 is set by D184<>E184 etc? If so, then simply select all of the cells first then enter the conditional format.
Hope that helps
Regards
Simon
Your post is a little confusing. You say, for example, that D190 contains D183<>E183.
Does it actually contains =D183<>183? This would return True or False as the cell value. If it contains D183<>E183, without the equals sign, Excel will treat this as text and will copy it verbatim. If the formula is =D183<>E183, then Excel will definitely amend the formula if you copy it to another cell. If there is a dollar sign in front of the column or row, then Excel will fix that value when you copy it. If there is a dollar in front of both the column and row, Excel will copy the formula without modification.
On the other hand, you are asking about conditional formatting. Is the formula =D183<>E183 your condition? Are you trying to apply conditional formatting to a range of cells such that the format for D183 is set by D183<>E183, the format for D184 is set by D184<>E184 etc? If so, then simply select all of the cells first then enter the conditional format.
Hope that helps
Regards
Simon
Thread Starter
Join Date: Apr 2005
Location: Bexhill-on-Sea
Age: 77
Posts: 48
Likes: 0
Received 0 Likes
on
0 Posts
First apologies for the confusing post, and thanks for the answers.
Simon
It was a conditional formating formula, I have done as you suggested and all is OK now, thanks you've saved me a lot of time.
Merch
Simon
It was a conditional formating formula, I have done as you suggested and all is OK now, thanks you've saved me a lot of time.
Merch
