I came across this the other day, and remembered I had encountered it before and 'got it to work' but it still bothers me. Is the conditional formatting dialog box reversed in the order it processes the rules. Attached is a simple spreadsheet with four sheets, each with the same rule. Column A has the CF applied. Column B is what I am expecting. So, using the first sheet 'Blue Then Green' as an example, my CF rules are: Top rule, if the row is odd then shade it blue. Secondary rule is that if the cell contains a 'b' then shade the cell green. I would think it would first go through and shade the odd rows, and then the second rule would overwrite any odd row that had a 'b' in it as green. That is not what I am seeing.
Curious if others see this (maybe some weird setting in my Excel) or if they can explain my misinterpretation of 'Rule (applied in order shown)' Excel states in the CF dialog box.
Bookmarks