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

Why does the order of CF matter

I have a spreadsheet that depending what happens in column A, cells in GH RS and AC AD will either high light Green in GR AC or red in HS AD. I noticed that I have had a cell high lighted in red forever and when I change the rule from top to bottom the red in the cell went away with no change in column A (its blank)

Why does it matter what position the ruling is in as long as all the rules are in the same position in each cell (all on top as 1st rule or all on bottom as last rule)

Thanks
 

Attachments

  • why does order matter on CF.jpg
    why does order matter on CF.jpg
    247.5 KB · Views: 0
As far as I know. The placement of the rules is the order in which they are processed. So its possible that because that rule was positioned first. It wasn't taking into account other rules. Might wanna check though. Can't really confirm whether there was another reason without a sample file
 
Back
Top