Keep It Simple Stupid
New Member
- Joined
- May 24, 2007
- Messages
- 26
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!
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!