Jack-P-Winner
Member
Perhaps I am doing this wrong. I already have the CF in all the cells that it needs to be but I am going back to add the following list of numbers
=IF(AND($A$3="?",$L$3="?"),1,"") (use a formula)
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
=$A$3="?" (use a formula)
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
Cell Value between =1 and =9
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
=$L$3="?" (use a formula)
=$C$3:$H$7,$C$11:$H$15,$C$19:$H$23,$C$29:$H$29,$C$32:$H$32,$C$35:$H$35,$N$3:$S$7,$N$11:$S$15,$N$19:$S$23,$N$29:$S$29,$N$32:$S$32,$N$35:$S$35,$Y$3:$AD$7,$Y$19:$AD$23,$Y$29:$AD$29,$Y$32:$AD$32,$Y$35:$AD$35,$Y$11:$AD$15
when I add this it also adds the string again to all the cells that have the conditional formatting.
=IF(AND($A$3="?",$L$3="?"),1,"")
=$A$3="?"
Cell Value between =1 and =9
=$L$3="?" (use a formula)
which is casuing me to have to go back in and delete them in all the cells .... needless to say sooooooooo time consuming
Am I doing this wrong and is this enough information that you understand what I am even talkng about LOL
=IF(AND($A$3="?",$L$3="?"),1,"") (use a formula)
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
=$A$3="?" (use a formula)
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
Cell Value between =1 and =9
=$G$3:$H$7,$G$11:$H$15,$G$19:$H$23,$G$29:$H$29,$G$32:$H$32,$G$35:$H$35,$R$3:$S$7,$R$11:$S$15,$R$19:$S$23,$R$29:$S$29,$R$32:$S$32,$R$35:$S$35,$AC$3:$AD$7,$AC$19:$AD$23,$AC$29:$AD$29,$AC$32:$AD$32,$AC$35:$AD$35,$AC$11:$AD$15
=$L$3="?" (use a formula)
=$C$3:$H$7,$C$11:$H$15,$C$19:$H$23,$C$29:$H$29,$C$32:$H$32,$C$35:$H$35,$N$3:$S$7,$N$11:$S$15,$N$19:$S$23,$N$29:$S$29,$N$32:$S$32,$N$35:$S$35,$Y$3:$AD$7,$Y$19:$AD$23,$Y$29:$AD$29,$Y$32:$AD$32,$Y$35:$AD$35,$Y$11:$AD$15
when I add this it also adds the string again to all the cells that have the conditional formatting.
=IF(AND($A$3="?",$L$3="?"),1,"")
=$A$3="?"
Cell Value between =1 and =9
=$L$3="?" (use a formula)
which is casuing me to have to go back in and delete them in all the cells .... needless to say sooooooooo time consuming
Am I doing this wrong and is this enough information that you understand what I am even talkng about LOL