If you don't need to /hide/ hide it (from users) the following will work in A2.

=IF(B1="Joe","What do you know?","***")



--
-SA


"DW" wrote:

Hey All,

I have a worksheet where I need to hide the contents of a cell (we'll say
A2)....such as making it all asterisks (*) just like a password field. But,
when another cell's (we'll say B1) value changes, A2 needs to reveal it's
true data.....and then when B1 is blank again, A2 needs to revert to
asterisks.

Example,

A1 B1 A1 B1
hello hello Joe

A2 B2 A2 B2
*** What do you know?

Anyway to do this? Thanks for any assistance.

Don