How to give color to a text in excel cell that has "YES" in different cells using VB or C# code or any other method without using hotkeys

Capture

Please find the image attached in which i want all text “YES” to be in red but only the text.

@karthikeyan.s1 - Please check this post…

Idea is same: Here you have to do .contains(“YES”)…That’s all…

Thanks much @prasath17 , but I asked for text color inside the cell not the cell background color, please see the attachment of the sample output that i preferCapture1

@karthikeyan.s1 - I guess, then you have to attempt using UI Automation and Send HotKey/Keyboard Shortcuts

Result
image