• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there a way to copy the formatting to another page

Hi ,

There is no way to only copy the formatting , since the formatting depends on a helper column.

You will need to copy the helper formulae in all the 5 columns , and the formula in the output column to the different worksheets ; if all the worksheets are identical , you may be able to copy the formatting. Try it and see , after you have copied all the relevant formulae.

Narayan
 
How do would I write the conditional formatting all at once? What I mean is I have completed them and they all work YAY!!! But again, thanks to you Narayan and you teaching me but I had to do one helper column PER entry in the CF at a time like this...

=NOT($AT2)
=NOT($BI2)
=NOT($BT2)

How can I open the CF and enter them all at one time? I know I have to highlight all columns involved. Would it be like this?

=NOT($AT2,BI2,BT2)
 
Hi Larry ,

I have not understood the context ; probably if you can upload a file , it will help.

From what I have understood , you have 4 columns of digits which change ; corresponding to these 4 columns , there is an output column which needs to be derived , as well as conditionally formatted. For these 4 columns of data , and the one column of formulae , there are 5 helper columns which are used to derive the output and conditionally format it.

These 10 columns are one group , which go together.

If you now have 3 such sets of columns in one worksheet , you cannot conditionally format them together ; each set has to be treated individually , and the CF rules have to be done for each set , individually.

Narayan
 
okay, maybe this makes better sense. I have the formatting done for column B. Can I write the code for O,AA,AO,BC all at 1 time when I do the conditional formatting or do I have to do them 1 at a time?
 

Attachments

Hi Larry ,

The problem is that the CF rules for column B are :

=$K4

and

=NOT($K4)

When these are copied to any other column , the $ sign in front of the column designation , it will not change. If you can first change the rules for column B to :

=K4

and

=NOT(K4)

then , when you copy them to any other column , the rules will adjust accordingly.

Narayan
 
Hi. Narayan,

Actually when I copy them to a new location even with the $ all adjust 100%. My question is on the use of the conditional formatting (making the numbers green and red). Can I program all of them at once? Basically high light all columns involved (the numbers I'm changing to green and red) then write the code for all "1" time or do I gave to open the CF and write the code per column? Does that make sense?
 
Hi Larry ,

The conditional formatting will not adjust !

You may still see some formatting but it will not be correct since it will be based on the wrong formula.

You need to first change the rule so that it does not use the $ sign for the column ; then when you copy the formula across , the CF rule will adjust itself correctly.

Narayan
 
You must log in or register to reply here.
Back
Top