How can I have Excel determine the CASE of data in a certain cell?

Example:
I want to check data in Column 2.
If this data is PROPER case, I want an @ in Column 1.
If the data is UPPER case, I want Column 1 to be blank.

Thanks, in advance, for your help.