Anchoring Named Cells + Custom Number Formatting

Hi Guys

I have 2 questions I need your assistance on please:

1) Is it possible to anchor a named cell (see my comment box in attached excel document). Perhaps I could use a certain function like search/find if this is not possible?

2) I am still having issues with custom number formatting (I have tried in vain numerous different combinations but cannot seem to get it correct - see comment box in excel doc attached). I am looking for a single custom number format that will NOT show the "," in front of the $50,000 (currently it is displaying the above cells correctly but when I copy the number formatting Cell B4 incorrectly displays $,50,000).

Thanks in advance for any help