Conitional Formatting

[Guest]

Hello.
I have two fields in a subform, "User" and "IT Announcement"
I would like to do conditional formatting to this effect:
On ther "User" field:
If "IT Announcement" = Yes then make the "User" field turn blue (I would
choose the color blue from the conditional formatting selection.

How would you write this?

Thanks.
Iram/mcp

 

[fredg]

Hello.
I have two fields in a subform, "User" and "IT Announcement"
I would like to do conditional formatting to this effect:
On ther "User" field:
If "IT Announcement" = Yes then make the "User" field turn blue (I would
choose the color blue from the conditional formatting selection.

How would you write this?

Thanks.
Iram/mcp

In design view, select the [User] control.
Click on Format + Conditional Formatting
In the Condition1 dropdown select
Expression Is
Write
[It Announcement] = "Yes"

Select the color you want.
Save the changes

Note: If [It Announcement] is a Yes/No datatype, then do not use the
quotes.

 

[Guest]

Thanks fredge. You are the man.
It was a Yes/No data type.

Iram

Hello.
I have two fields in a subform, "User" and "IT Announcement"
I would like to do conditional formatting to this effect:
On ther "User" field:
If "IT Announcement" = Yes then make the "User" field turn blue (I would
choose the color blue from the conditional formatting selection.

How would you write this?

Thanks.
Iram/mcp

In design view, select the [User] control.
Click on Format + Conditional Formatting
In the Condition1 dropdown select
Expression Is
Write
[It Announcement] = "Yes"

Select the color you want.
Save the changes

Note: If [It Announcement] is a Yes/No datatype, then do not use the
quotes.