chaosincarnate
New Member
Howdy,
Here's a simple question with an elusive answer (at least to me).
I have a dozen or so boxes that when any of the = 0 i want them to be "hidden" the conditional formating changes the color to match the background color and they become "hidden" simple enough.
Here's the problem....
If the conditional format says 0 in this cell = green and i get anything that totals up to an number with 0 in it it changes it to green. ie 10 , 20, 30.
How do i get it to only do 0 and not anythng that contains a 0.
Only using Conditional Format Highlight Cells rule: Texts that contains
Any help would be appreciated.
Here's a simple question with an elusive answer (at least to me).
I have a dozen or so boxes that when any of the = 0 i want them to be "hidden" the conditional formating changes the color to match the background color and they become "hidden" simple enough.
Here's the problem....
If the conditional format says 0 in this cell = green and i get anything that totals up to an number with 0 in it it changes it to green. ie 10 , 20, 30.
How do i get it to only do 0 and not anythng that contains a 0.
Only using Conditional Format Highlight Cells rule: Texts that contains
Any help would be appreciated.