Kingchaos64
New Member
- Joined
- Jan 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I'm wanting to make a list next to a table. I would like that list to automatically check the data in the table and highlight a cell in the list if it matches a cell in the table. It also needs to match Today's date. My table is a column of bus numbers, dates, baggage on, baggage off and so on. There is 20 plus busses a day and it's hard to keep track if Ive entered all the busses for that day or not.
So I would like to make a column List on the side of the table with all the bus numbers and that List would check the table for a bus number plus today's date if found I would like that bus number in the List to highlight.
Is this a possibility?
Any help would be greatly appreciated.
My table headers start on A5 to P5
Data starts A6 to P1000
The Date column is A and the Bus column is B
So I would like to make a column List on the side of the table with all the bus numbers and that List would check the table for a bus number plus today's date if found I would like that bus number in the List to highlight.
Is this a possibility?
Any help would be greatly appreciated.
My table headers start on A5 to P5
Data starts A6 to P1000
The Date column is A and the Bus column is B