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

conditional formatting order

Jack-P-Winner

Jack-P-Winner

Member
I just want to make sure I am correct in my logic.

I have 10 sheets in a book that are all programmed the same exact way (or supposed to be) I have noticed when I go through my CF for each sheet a couple of them are in different order when I go to manage rules. Shouldn't they all be in the same order?

Example the first line one in one sheet says this

=IF(AND($AF$21="D",$AV4>$W$21),1,"")

The next sheet says this

=IF(AND($AF$21="D",$AV5>$W$21),1,"")

The =IF(AND($AF$21="D",$AV4>$W$21),1,"") is perhaps 15 lines down. Don't I need to bring that one up first as well?

As always thanks
 
CF works by going through the CF list top to bottom, if it finds a condition that fits a CF rule, then it will carry out the rule, then move on to the next, with a lot of CF the rules can be conflicting one or another, which means if a certain rule is carried out the CF will not check other rules, this can be very frustrating but all you can do is go through the rules to check that formulas are not overriding each other. You have the choice as to what order they run in.
 
Thanks Bob, I think that may be my entire issue having an enormous amount of CF and I think some are fighting for first position. Looks like I am about to do some long hand writing LOL, wish there was an easy way to check CF
 
 
You must log in or register to reply here.
Back
Top