I have a excel sheet, I need to color the Row - (plz dont send me the copy paste code & plz go through the requirment)

Rajendra Tripathy

Sep 21 2009 9:02 AM

3.1k

I have a excel sheet Which Contain this type of rows & coloums(Below) .
As per my requirement I am getting the value of phone say (String PhoneNo- 565778 ).
Now I have to serch the ROW which contain that value"565778".
After that I need to color that Row Yellow, Or I can Bold that Row also.

Excel (Sheet1)

Name     Address       Phone

x            ddddd         123456
y            mmmm        676868
z            jshcjh          565778
n            hghhh         878766

Please let me know the Code in C#.

Regards
RAJ.