Share via

Conditional Formatting using text

Anonymous
2019-06-25T21:50:50+00:00

I would like to use conditional formatting to search for a key word within a string of text and apply the formatting.

Example:  When the field name "Status" contains the word "Min\Max" within the string of text apply the conditional formatting.

Using the Expression function within the Conditional Formatting window I thought [status]="*Min\Max*" would work, but this is not the case.

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.

0 comments

Answer accepted by question author

  1. Anonymous
    2019-06-25T22:00:28+00:00

    You need to use the expression [status] Like "*Min\Max*"

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest