Conditions

  • Thread starter Thread starter john
  • Start date Start date
J

john

Hello,

Given the particular information in a cell, I would like
another cell in the same record to become populated with
1 of 3 possibilities. How do I go about accomplishing
this?

Thank you.
 
Look at the Conditional Formatting under the Format Menu
in design mode. You should be able to get what you want
from there.
 
john said:
Given the particular information in a cell, I would like
another cell in the same record to become populated with
1 of 3 possibilities. How do I go about accomplishing
this?
Click to expand...


That's a pretty vague description, but one way would be to
use an expression in the "another" text box:

=IIf(txtbox = possibilty1, value1, IIf(txtbox = possibilty2,
value2, value3))
 
Back
Top