A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

copying conditional formats



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2009, 08:37 PM posted to microsoft.public.excel.misc
Ron
external usenet poster
 
Posts: 690
Default copying conditional formats

I've created a conditional format that colors red cell A1 if the value of
cell A1 is less than cell B1. Next, I copied this format into the cells
A2:A100.

EXAMPLE
col A col B
row1: 80 90 highlight cell A1
row2: 98 95
row3: 70 98 highlight cell A3
....
row99: 82 90 highlight cell A100
row100: 90 85

In Excel97 this copy worked fine... in Excel 2007 when I select each of the
cells A2 thru A100 and examine the Rule Manager it shows the same rule
comparison cell... Rule Cell Value $A2 is applied to group of cells
=$A$2:$A$100. It appears to have worked correcly, in that A2 is compared to
B2, A3 to B3.... A100 comared to B100. However, when I examine the
conditional rules for each of cell A2 thru A100 the Rules value is always
listed as $B1. Because the cell formatting result appear to work
correctly... this would mean that it must be incrementing the Rule value for
each cell. If this is the case, I don't feel confortable that the Rule Value
is always $B1 for all these cells because I cannot be certain that the
comparison is being done correctly. I would perfer to see a similar
formating result like in Excel97. As a work around, I've resorted to coping
the format into only one cell at a time so that each Rule value correlates
with the cell, however this is a very painful process when doing individual
100 copies.

Is there a simplier way of doing this format copy what will show the acual
rule cell used?
  #2  
Old November 12th, 2009, 09:01 PM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default copying conditional formats

Is there a simplier way of doing this format
copy what will show the acual rule cell used?


Unfortunately, that's how Excel 2007 displays the CF rules. Doesn't make any
sense to me (and many others, I'm sure!).

Poorly designed. Period!

--
Biff
Microsoft Excel MVP


"Ron" wrote in message
...
I've created a conditional format that colors red cell A1 if the value of
cell A1 is less than cell B1. Next, I copied this format into the cells
A2:A100.

EXAMPLE
col A col B
row1: 80 90 highlight cell A1
row2: 98 95
row3: 70 98 highlight cell A3
...
row99: 82 90 highlight cell A100
row100: 90 85

In Excel97 this copy worked fine... in Excel 2007 when I select each of
the
cells A2 thru A100 and examine the Rule Manager it shows the same rule
comparison cell... Rule Cell Value $A2 is applied to group of cells
=$A$2:$A$100. It appears to have worked correcly, in that A2 is compared
to
B2, A3 to B3.... A100 comared to B100. However, when I examine the
conditional rules for each of cell A2 thru A100 the Rules value is always
listed as $B1. Because the cell formatting result appear to work
correctly... this would mean that it must be incrementing the Rule value
for
each cell. If this is the case, I don't feel confortable that the Rule
Value
is always $B1 for all these cells because I cannot be certain that the
comparison is being done correctly. I would perfer to see a similar
formating result like in Excel97. As a work around, I've resorted to
coping
the format into only one cell at a time so that each Rule value correlates
with the cell, however this is a very painful process when doing
individual
100 copies.

Is there a simplier way of doing this format copy what will show the acual
rule cell used?



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.