I wish to hide the data in a cell containing a formula until data is entered into another cell. Something like this:
"If B11 is blank, then text in B12 is white". B12 is the cell containing a mathematical formula.
Is there a way to do this?
Mac mini (M1, 2020)
You might be able to do something like this with conditional highlighting (I use B2 and B3 in my example):
The equation is B3 will be white text if B2 is blank. It will be normal if there is anything in B2 other than the same text (or the start of the same text) as what's in B3. Without knowing what will be entered into the cell, I don't know if this will work for you or not.
Hi Pete,
The NULL character is ""
Formula in B12: IF(B11="","",<formula>)
If B11 is blank, then insert blank, else insert the result of the formula.
Regards,
Ian.
Use conditional formatting
Unfortunately the standard conditional formatting options provided don't do the job I want, but thanks for your reply.
Thanks, but I think I will go with Yellowbox's solution.
Ngā mihi
Thanks Ian,
That works perfectly.
Pete
Hi Pete,
I am glad to help. Thanks for your feedback and the green tick.
Happy Numbering!
Ian.
In Numbers, hide text in a cell based on state of another cell
