Sorta, kinda :)
Depends on how much work you want to do :)
First and foremost, understand that the NOW() function only updates when the sheet is edited in some way - it isn't possible (at least without external support) to have a continuous timer running on a sheet.
That said, the second step would be to use Conditional Formatting, which you can use to automatically change the formatting (e.g. color) of a cell based on its contents.
In this way you could create a cell with the Conditional Highlighting to change the color to green if the cell value is higher than a cell containing the =NOW() formula.
E.g. if cell $B$2 contains the formula "=NOW()" then you can:
So now the cell will turn green if the date in the cell is in the future.
However, Conditional Highlighting only takes one dimension - in other words, all future flights will turn green, not just the next one (to do that you have to compare it to not only NOW(), but also the other departure times in the list.
It's also a little more complicated by the fact that, internally, Numbers uses full dates, even if it only displays a time.
For this I mean that if you type "3:00pm" into a date cell, Numbers would internally reference that as "1/8/2024 3:00pm" which would be a problem tomorrow when NOW() returns '2/8/2024 3:00:00pm" and all your departure times are in the past.
You can get around this by stripping the date component and just storing a time value - in other words, instead of entering '3:55pm' in the field (which Numbers would assume meant 3:55pm today), you would enter "=TIME(15,55,0)' so that it only captured the time, regardless of the date.
You'd have to do something similar with your =NOW() function to strip out the date component.
The function:
=TIME(HOUR(NOW()), MINUTE(NOW()),0)
would give you the current HH:MM time in a cell, regardless of the date.
To take this to the next level (e.g. to only highlight the next viable flight) you'd need to either do some fancy lookups (offhand I can think of creating a separate table of times and using LOOKUPs to find the next), or use AppleScript to drive Numbers under the hood. Both of which are big steps up.
