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.
Loading

Master BillaPosted Sep 21, 2009, 9:55 AM
Yes i can give a hint to you, just read the row and check value of the that cell, if it found then you can set color to that
range.Interior.Color = System.Drawing.ColorTranslator.ToWin32(Color.Purple);
Thank you