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

[karthikeyan.s1 (Karthikeyan S)]

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

[prasath17 (Guru)]

@karthikeyan.s1 - Please check this post…

How to mark color in particular cell value in excel

Hi Guys, I need to mark Red in above 15min (00:15:00) time in one column and below 15 min show to green Example, i have values in times(00:04:00) ,(00:10:00) in one columns , i need to find above(00:15:00), once find above (00:15:00) i want automatically mark color red, otherwise shows Green , [time] please anyone help me out from this. Regards, Raja G

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

[karthikeyan.s1 (Karthikeyan S)]

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 prefer

[prasath17 (Guru)]

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

Result