Need cell value for row color

Aspose.Cells Product Family
1
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?
2

Hi,

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.

( Find or Search Data|Documentation )

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.

( Format Rows and Columns|Documentation )