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

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.
 
G

Gord Dibben

Select A2 and Format>CF>Formula is: =ISBLANK(A1)

Format to white font.


Gord Dibben MS Excel MVP
 
J

Jules

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

default values in a cell 1
Counting a single value in a cell? 8
Keep adding to one cell to carry a total in another 7
Excel Conditional Formatting 1
Excel In Excel how can I block the contenent of a cell? 0
Change data from one cell to another cell 4
sum a cell value over 75 7
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1

Top