Conditional Formatting

[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

 

[Allen Browne]

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.

 

[Pam]

Thanks, Allen. It worked perfect! I had tried several combinations and
could get nothing to work!! Again, thanks for your time and help.

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.

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.