You can't make a Pop-up appear with just a formula........you need VBA for
that. What you could do is just do Conditional Formatting on the cell to
turn it Bright RED if the first cell contains "collateral" and this one is
not yet populated.

Vaya con Dios,
Chuck, CABGx3



"srain001" wrote:

Hi,

I'm looking for a way to make a "pop-up" appear when a particular cell is
left blank.

For example,

If cell 1 in Column A is filled with the term "Collateral" (picked from
dropdown), then cell 1 in Column D must be filled. I'm looking for a formula
or macro to make this mandatory so that people filling out the spreadsheet
cannot ignore column D when that specific entry is used in column A.

Any help would b great. Tnx!
srain