|
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)
__________________
The thing about quotes on the internet is that you cannot verify their validity.- Abraham Lincoln
Last edited by Kevy Baby : 02-03-2009 at 08:35 PM.
|