To search from the active cell from left to right row-wise select By Rows in the Search To check from top to bottom columnwise select By Columns. Step for using the VALUE Function Select the Formulas tab. Then select that cells that contain negative values as per syntax.
The B290 part of the formula is a way that you can subtract 10 from the value in cell B2.
If this array is the final result ie. Essentially the function will convert a numeric value into a text string. Then select that cells that contain negative values as per syntax. To fine-tune the search click on the Options in the right-hand corner of the Excels Find Replace dialog and then try any of the below options.