finding numbers in excel

[ms]

I have several columns of numerical values, but over 1000 rows.
Within the 1000+ rows, there is about 800 consecutive rows that I am
interested in. I am interested in the values between when the
numerical value goes below (starting row) a certain threshold and then
go back above (ending row) this threshold (lets just say 5 for
example). However, this changes with each column, but the threshold
value remains the same. Therefore, I would like to find the starting
row and ending row of the values of interest. So if I have the
following:

7
9
6
3
4
1
8

I would like to find row4 (where 3 value is located) and row6 (where 1
value is located). Is this possible in Excel? I was thinking of an
if statement, but don't think that would work here. Anything to
return the actual row value?

 

[Spreadsheet Solutions]

Try conditional formatting to light them up.
Depending on your Excel version (03 or 07), many different options are
available.

Try Help / F1 and I think you'll find what you are looking for.