• 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.

View Conditional Formatting

Jack-P-Winner

Jack-P-Winner

Member
Is there a way to copy and paste all the CF that is on a work sheet without going down rule by rule? I have 10 sheets that I am trying to evaluate to make sure they are all done the same way. I already know they are not but need to compare them and make changes OR delete them all and start over
 
Is there other formatting on the sheet that you DON'T want copied? If not, you can select all the cells on first sheet, select second sheet, Paste Special - Formatting.
 
I don't think so Luke, I was hacked pretty bad last September and fighting errors ever since. I have several errors I have bee trying to fix (some I posted here without any luck) so I was thinking about clearing them all out and pasting them back. Just to give you an example. Here is the same cell on two different sheets supposed to be dong the same thing

=$L$3="?" =$N$3:$S$7,$N$11:$S$15,$N$19:$S$23,$Y$3:$AD$7,$Y$11:$AD$15,$Y$19:$AD$23,$C$3:$H$7,$C$11:$H$15,$C$19:$H$23,$C$29:$H$29,$N$29:$S$29,$N$32:$S$32,$N$35:$S$35,$Y$29:$AD$29,$Y$32:$AD$32,$Y$35:$AD$35,$C$32:$H$32,$C$35:$H$35

=$L$3="?" =$AC$11:$AD$15,$AC$3:$AD$7,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$AC$19:$AD$23,$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35

=$A$3="?" =$AC$11:$AD$15,$AC$3:$AD$7,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$AC$19:$AD$23,$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35

=ISEVEN($A3) =$G$3:$G$7,$G$11:$G$15,$G$19:$G$23


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX


=$L$3="?" =$G$11:$H$15,$G$19:$H$23

=$A$3="?" =$G$11:$H$15,$G$19:$H$23

=ISEVEN($A11) =$G$11:$G$15,$G$19:$G$23

=$L$3="?" =$C$3:$H$7,$N$3:$S$7,$Y$3:$AD$7,$C$11:$H$15,$C$19:$H$23,$N$11:$S$15,$N$19:$S$23,$Y$11:$AD$15,$Y$19:$AD$23

=$L$3="?" =$G$11:$H$15

=$A$3="?" =$G$11:$H$15

=ISEVEN($A11) =$G$11:$G$15

=$L$3="?" =$G$3:$H$7,$R$3:$S$7,$AC$3:$AD$7,$G$11:$H$15,$G$19:$H$23,$R$11:$S$15,$R$19:$S$23,$AC$11:$AD$15,$AC$19:$AD$23

=$A$3="?" =$G$3:$H$7,$R$3:$S$7,$AC$3:$AD$7,$G$11:$H$15,$G$19:$H$23,$R$11:$S$15,$R$19:$S$23,$AC$11:$AD$15,$AC$19:$AD$23


=ISEVEN($A3) =$G$3:$G$7,$G$11:$G$15,$G$19:$G$23


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