I have a spread sheet set up. And, for the column wherein I would like
to input percentages, the percentage may vary depending on the product.

It could be at 20% one day and at 30% another day. Can I get excel to
'ask me' or prompt me to input the 'percentage' based on change in product
or change in day, etc????

Question: Is excel set-up to 'prompt' me to input a percentage for certain
fields???