Conitional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
Thanks fredge. You are the man.
It was a Yes/No data type.

Iram

fredg said:
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
Click to expand...

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.
Click to expand...
 
Back
Top