Hi Matt
this is not possible with the build-in functionality in Excel. I could
imagine trying the following to achieve something similar
- format the cell with a white font color
- use the selection_change event of this worksheet:
- if this specific cell is selected ask for a password
- format the cell with a black font color if the pwd is correct
- in all other cases (other cells are selected) change the font
color to white

Note: a determined user will simply change the font color of the whole
column - no chance to prevent this if the worksheet is not protected.
So in your case I would protect the entire worksheet but lock only
these specific cells. You may add to this the selection change event
and unlock the worksheet (and therefore show the cell contents) if the
user enters this cell


--
Regards
Frank Kabel
Frankfurt, Germany

Matt wrote:
Is it possible to password protect an individual cell (rather than
the whole sheet) so that some cells appear blank and if selected
they prompt for a password for viewing? Thankyou for any help.