in my Excle sheet
Which is happen first according StockMarketTime
The highest score in (highScore column) OR the lowest score in (lowScore column).
In my example, the equation should return with the row 7, of StockMarketTime = 12:00 and the highScore = 19, because it happen before the lowest score at row 11, StockMarketTime = 02:00 and the lowScore= 12
So the comparison should always happen in between these two results only (the highest score in column StockMarketTime, and the lowest score in column lowScore)
I need the result to highlight the row that match my needs.
there is attached Excel file