• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formating

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.
 
Back
Top