Excel Question #46

[Moonliner]

Originally Posted by Kevy Baby

Okay, I know I am going to smack my forehead when the answer gets posted because I know the answer is painfully simple and I am just clueless on this one.

I want the text in cell A1 to not print if the value in cell A2 is blank. I thought the easiest way to accomplish this was to conditionally format cell A1 with a white font if A2 is = 0. However, what is the stinking formula I would need to enter into the "Formula Is" cell in Condition 1 to accomplish this? I know how to set the formatting once I have a True result.

ETA: I found my own answer. The syntax was what was confusing me. In the cell, I had to enter =(A2=0)

Dammit, how can I look brilliant if you go and answer your own questions?