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

Adding to my conditional formatting adds info two times

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 you highlight GH 3-7 and look at CF it is correct, then highlight another set like RS 3-7 AC AD , GH 11-15 19-22 and so on and you will see what I mean by placing the same info again minus all the string of numbers. I do not need them in their twice
 

Attachments

  • CF doubled.xlsx
    68.5 KB · Views: 2
Hi Jack,

W/o getting too deep in the problem, as your problems seem to make me do mental backflips (ha ha), my first thought would be to create named ranged for your cells. Define a range called "ColorThese" defined as:
=$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

Then in your CF, you can tell the CF to apply to ColorThese. Benefit here is that it's less typing, and far easier to make changes in the future if you need to redegine ColorThese.

If we had one giant range defined that you applies CF to, it would be easier to delete all current rules in entire sheet (since there's so many duplicates), and rebuild doing somethiing like
Green format applies to ColorThese
Red format applies to ColorThese
...
etc.
 
Darn Luke I hardly learned and built confidence with CF to change my way of thinking lol. I need to read up on defining a range and exactly how to use it. I'm a visual kind of person so reading tutorials takes me a while to sink in lol. BUT if you playing the powerball tonight play ball 1 and 4 ODD. Ball 1 under 15 Ball 5 Even see if you can hit that jackpot for me

Thanks

Let me check out a video or two
 
Back
Top