Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
INSTR(1,fieldname,"Waiting")>0
conditional formatting if field contains
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Would just like to know what the code would be in Conditional formatting for the following.....
If the field contains the word "waiting" then I'd like to turn it blue
Waiting on Tech
Waiting for parts
Waiting for response
Waiting on order
I've already used two of the formats on other items. Would just like it to change anything with the word "waiting" in it.
Any ideas?
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Answer accepted by question author
-
Anonymous
2012-06-26T15:40:29+00:00
1 additional answer
Sort by: Most helpful
-
Anonymous
2012-06-26T15:43:42+00:00 Select Expression Is in the first dropdown.
Enter the expression
InStr([FieldName],"waiting")>0
where FieldName is the name of the field.
Specify the desired formatting.
Click OK.