We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Need cell value for row color

How to i search my worksheet for a cell value of 7, then set the entire row to gray if that 7 is found somewhere?


Thanks for your posting and considering Aspose.Cells.

Please first find your desired value or data inside the worksheet using the approach mentioned in this article.

( http://www.aspose.com/docs/display/cellsnet/Find+or+Search+Data )

Once, you have found the value or cell containing your value, then you get the row number and apply style format to entire row as mentioned in this article.

( http://www.aspose.com/docs/display/cellsnet/Formatting+Rows+and+Columns )