Macro to review chat log

Hi,

During my job I have to review the chat history of the members to check if they have been using false language with other members. For this currently I have to manually review each chat log which is a very time consuming activity.

Reaching out to the excel guru's to advise if there is a possibility of building a macro which once run will identify and highlight the chat log where the member used false language and ease my work.

Thanks in advance for reviewing the post.

Amit

Not sure what exactly you are asking as I am not that tech savy, All i can tell is that the hat log is sent to me and I open it in Excel to review the chat log.

It can be done in Excel. Keywords can be highlighted in a different color. It would be very helpful if you could attach an example, with no private information included.

But again--What is "false language"? You have to be very specific about this.