Triggering excel fields

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I'm running Excel 2000. I have created a spreadsheet that
I would like to "trigger" a field to be populated when
another field on that same line is used. One of the
problems I find is that I have multiple spreadsheets, each
with a different amount to be triggered. Each sheet has
the same amount though.

Any help would be appreciated.
 
I'd use a helper cell that was formatted Red, bold and with arrows pointing at
the cell that needs to be filled in:

=if(a1="","","<=== Please fill this in!")

When A1 is empty, you don't see the message. As soon as you put something in
A1, you get that irritating message.
 
Back
Top