Hey guys, this is my first post. This forum seems to be real nifty and I will definitely be checking the various posts out.
I work for a small nonprofit organization that serves adults with intellectual and developmental disabilities. We are regulated by our state to track the resident's finances to protect their security. Most of our group homes are continuing to do this on paper (major yawn, waaaay to much work for the 21st century in my opinion). Attached is the form that we are using in the homes I oversee. I have several formulas and conditional formatting options in place that I am happy with. My question is this:
I want to keep the formula that is presently there in H6, however I also want to add the condition or formula (sorry, not extremely excel savy here) that if C6 contains no text, then H6 turns to white font so that it isn't visible. Can anyone help me out here and tell me how to do this?
Lock Box Template - 2.xlsx
Bookmarks