bug of conditional formatting?

[6diegodiego9]

I can't explain the fact that "6" is left red instead than blue:

Is this a known bug of conditional formatting?

I only used simple font color and background formatting in both the rules, no more than this:

The two cells are originally not colored:

 

[SanjayGMusafir]

Did you try changing the order of rules and checked?

 

[Sufiyan97]

I can't explain the fact that "6" is left red instead than blue:

it is already greater than 5
So shouldn't it be red?

am I guessing it right?

I can't explain the fact that "6" is left red instead than blue:

View attachment 74012

 

[Fluff]

Is this a known bug of conditional formatting?

NO, it's doing exactly what it's meant to do.

The top rule takes priority over all other rules, so the cell remains with a red font.
With your 2nd example, your formats are different so it applies the fill colour for 6, but keeps the font red.

 

[Joe4]

When you have multiple rules with overlapping true portions (i.e. anything greater than 5 meets BOTH of your rules criteria), you need to distinguish which rule "wins" in thos situations.

There are a few ways you can do that. One is to order them properly (like Fluff mentions) and maybe make use of the "Stop if True" checkboxes (on the far right side of your rules). This ensures that once a higher order rule's conditions are met, it stops there and does not check the other rules.

Another option is to re-write your rules so that you have no overlap between them (this is my preference, as then order of rules does not matter).
So maybe replace your:

=A1>3

rule with this:

=AND(A1>3,A1<=5)

 

[6diegodiego9]

NO, it's doing exactly what it's meant to do.

The top rule takes priority over all other rules, so the cell remains with a red font.
With your 2nd example, your formats are different so it applies the fill colour for 6, but keeps the font red.

The window says "Rule (applied in order shown)", so I expect it to color red first, and blue second. If I do the same (red then blue) with two consecutive VBA lines, it's left blue.
Where does your contrasting rule "The top rule takes priority over all other rules" come from?

 

[Peter_SSs]

Where does your contrasting rule "The top rule takes priority over all other rules" come from?

Go to this page and look at the 'Manage conditional formatting rules' section (& the section after that).