I am comparing two excel fi开发者_C百科les cell by cell. One is source file and another is target file.I want to color those cells which are not matching in the target file. Is there any way to do this without creating any other excel sheet for those cells which are not matching. I mean to say I want to fill color in those cells which are not matching in target file..
oResizeRange is a range of cells you selected. It's of type Office.Interop.Excel.Range
oResizeRange.Interior.ColorIndex = someindex;
Source
精彩评论