Hello, Good day. Kindly help me with my problem. I want have a conditional formatting of my Vehicle List to check availability. Red if under Departure Time is filled up and No Fill if Arrival Time is filled up. I am using a Helper columns. My problem is If there are multiple transactions in a day, an INDEX MATCH will only read the 1st Departure time and Arrival Time.
How to Do INDEX MATCH but read the Right most part of the Column not the First?
vehicle.PNG
Bookmarks