Value in one cell visible of another cell has anything in it

  • Thread starter Thread starter Jules
  • Start date Start date
J

Jules

I used to know how to do this, and can't remember. I think it is a COUNTIF
function in the first cell, together with conditional formatting in the 2nd
cell, but I can't remember how to set it up.

cell A1: any text at all entered will cause cell A2: part number to be
visible.

cell A1: empty > value in cell A2 remains hidden.
 
Select A2 and Format>CF>Formula is: =ISBLANK(A1)

Format to white font.


Gord Dibben MS Excel MVP
 
Thanks Gord. If I could have edited this post or deleted it I would have, I
put it in the wrong place. Thanks for the quick response!
 
Back
Top