I'm having a brain cramp...

I have a workbook with 2 worksheets in it. Worksheet "all" has ~4500 rows
in it. Worksheet "some" has ~100 rows in it. There is a column called
"time" in both worksheets. They are both sorted ascending. Both are
column A.

For each row in "some", I want to find the row in "all" whose time is
closest to the time in "some". When I find that row, I want to set the
value in column B of "all" to the row number of the corresponding time in
"some" and I want to color all of that row in "all" red.

Is there an easy way to do what I want?

Thanks!
Bruce

--
+-------------------+---------------------------------------------------+
Bruce Bowler | Above all, we cannot afford to live in the present.
1.207.633.9600 | - Thoreau
|
+-------------------+---------------------------------------------------+