I have been doing a ton of reading and from what I can tell, there is
no "simple" solution to my problem. I have a range of cells that I
need to hide from joe user 1 but if joe user 2 has the password he can
see and edit the cells. Does this make sense? There are multiple
people that have access to this spreadsheet which is necessary. The
problem is that this sheet contains "sensitive" data that relies on
the rest of the information on the sheet. Thanks in advance for your
time.

Mike