Conditional Formatting

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

How can I enter a condition for two fields? I want a lt green background
with red text if the following conditions are met: HotJob = Yes (redtxt)
and PumpType="Manufacturing" (green background). This will be on a datasheet
subform. Not sure how, or if, this can be written into one condition.
Nothing I've tried so far has worked. I've already used the other
conditions. As always, help is very much appreciated.
Thanks,
Pam
 
In form design view, select the text box to be formatted, and choose
Conditional Formatting on the Format menu.

Choose:
Expression

Set the expression to:
([HotJob] = True) AND ([PumpType]="Manufacturing")

Apply the colours in the bucket and A icons.
 
Thanks, Allen. It worked perfect! I had tried several combinations and
could get nothing to work!! Again, thanks for your time and help.
Allen Browne said:
In form design view, select the text box to be formatted, and choose
Conditional Formatting on the Format menu.

Choose:
Expression

Set the expression to:
([HotJob] = True) AND ([PumpType]="Manufacturing")

Apply the colours in the bucket and A icons.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Pam said:
How can I enter a condition for two fields? I want a lt green background
with red text if the following conditions are met: HotJob = Yes (redtxt)
and PumpType="Manufacturing" (green background). This will be on a
datasheet subform. Not sure how, or if, this can be written into one
condition. Nothing I've tried so far has worked. I've already used the
other conditions. As always, help is very much appreciated.
Click to expand...
Click to expand...
 
Back
Top