Changing Cell Value doesn't update Conditional Format

[Keep It Simple Stupid]

I have a conditional format across many cells in a macro that if the cell value = 0 then the font will be white.

It works great originally, but if I put something else in the cell (other than 0) it doesn't automatically change the font to black, it stays as white. The only way that I can get it to update is to make a change to the cell, then go into Manage Rules, Edit the Rule, and then click Apply.

I'm sure there is something simple that I am missing, but I can't find any other posts that really answer my question so any help is appreciated.
Thanks in advance!

 

[Tom Urtis]

Maybe it's because of the formula rule itself. Post the formula so someone can see if there's a loophole in it causing the problem.

 

[Keep It Simple Stupid]

Good idea! Basically I used the Conditional Formatting Tool. I selected cells B3:M25 and selected Format only cells that Contain.
Then in the rule description...
Cell Value - Equal to - 0

In the macro code it looks like this

    Range("B3:M25").Select
    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
        Formula1:="=0"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False
    Range("B3").Select

 

[Keep It Simple Stupid]

I am still confused on this one. Does anyone have any ideas???

 

[shg]

Not responsive to your question, but why don't you just use a format that surpresses display of zero, e.g., General;-General;;

 

[viceb]

I am still confused on this one. Does anyone have any ideas???

If the conditional formatting works for Zero..do you have it set as BLACK for anything >0?