You could create a formula text field and use the Contains() function in an If() statement to return "agitated" if the filed contains the word agitated. Then you can make a table report filtered to only show records that return the word "agitated." You can do color coding of a field, but not a single word without custom coding.
Example:
If(
Contains([specific field],"agitated")=true,"agitated",
""
)
Result:
------------------------------
Adam Keever
------------------------------
Original Message:
Sent: 11-01-2019 13:20
From: Joshua Crunelle
Subject: Color Coding
Does anyone have a formula for highlighting a list of words that should not be in a specific field? For example: when a staff member is typing in comments about a day and use the word "agitated". which is not to be used in comments. How do I get the word "agitated" to be highlighted so when I'm browsing the comments it's easy to spot.
------------------------------
Joshua Crunelle
------------------------------