Make a checklist type of thing

[Kingchaos64]

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

 

[Kingchaos64]

Wouldn't there be a formula to put in Conditional Formatting Highlight Cells Rule? like, IF "A" column cells = TODAY() match the corresponding "B" column with "S" column. Highlight "S" matching cell. Then there would be no need for column R (the other date column). So basically the rule would be looking of any cells in A Column with today's date, looking at the next cell over and matching it with a cell in S column. Highlighting the S cell.

 

[etaf]

A=BUS Number
B=Today

Then in S you want to Type out a list of BUS Number that you entered today and see if those numbers MATCH in the column A and with todays Daye in B

 

[etaf]

does this work

Conditional format rule for A6 to Q1000
=AND(COUNTIF($R$6:$R$1000,$A6)>0,$B6=TODAY())
Tests to see the Bus number in Column A is in the Check LIST in Column R and todays DATE in Column B - so BUS entered today based on checklist


JUST in column R - the LIST to check
conditional formatting
=COUNTIFS($A$6:$A$1000,$R6,$B$6:$B$1000,TODAY())
See if the number in the LIST in R has been entered today - If it has highlight
You could change to add =0
=COUNTIFS($A$6:$A$1000,$R6,$B$6:$B$1000,TODAY())=0
to highlight bus number that are in the LIST and NOT entered today

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
5	BUS	Date																Check List	Bus Number in Data	BUS NOT entered
6	31	1/31/21	TRUE															99		BUS Number NOT entered today
7	43	1/31/21	TRUE															43	Bus Number entered today
8	55	1/31/21	TRUE															88		BUS Number NOT entered today
9	67	1/31/21	TRUE															55	Bus Number entered today
10	30	1/31/21	TRUE															101		BUS Number NOT entered today
11	42	1/30/21	FALSE															31	Bus Number entered today
12	54	1/30/21	FALSE															42		BUS Number NOT entered today
13	66	1/31/21	TRUE															66	Bus Number entered today
14	29	1/29/21	FALSE																	BUS Number NOT entered today
15	41	1/29/21	FALSE															53	Bus Number entered today
16	53	1/31/21	TRUE																	BUS Number NOT entered today
17	65	1/29/21	FALSE															30	Bus Number entered today
18	28	1/28/21	FALSE
19	40	1/28/21	FALSE
20	52	1/28/21
21	64	1/28/21
22	27	1/27/21
23	39	1/27/21
24	51	1/27/21
25	63	1/27/21
26	26	1/26/21
27	38	1/26/21
28	50	1/26/21
29	62	1/26/21
30	25	1/25/21
Sheet1

Cell Formulas
Range	Formula
S6:S17	S6	=IF(COUNTIFS($A$6:$A$1000,$R6,$B$6:$B$1000,TODAY())>0,"Bus Number entered today","")
T6:T17	T6	=IF(COUNTIFS($A$6:$A$1000,$R6,$B$6:$B$1000,TODAY())>0, "","BUS Number NOT entered today")
C6:C19	C6	=B6=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R6:R1000	Expression	=COUNTIFS($A$6:$A$1000,$R6,$B$6:$B$1000,TODAY())	text	NO
A6:Q53	Expression	=AND(COUNTIF($R$6:$R$1000,$A6)>0,$B6=TODAY())	text	NO

 

[Zot]

Good. It looks like you have got the solution only. I'm not that good in Excel formula. After looking at etaf worksheet, I finally get the idea of what you were trying to achieve.

Instead of highlighting the Bus on service for today and look at the schedule table, why not just create a list of bus like below as summary. Just another alternative.

Bus On Duty.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Bus No
2	25/1/2021	1												11
3	26/1/2021	2												20
4	27/1/2021	3
5	28/1/2021	4
6	29/1/2021	5
7	30/1/2021	6
8	1/2/2021	7
9	1/2/2021	8
10	2/2/2021	9
11	3/2/2021	10
12	31/1/2021	11
13	5/2/2021	12
14	6/2/2021	13
15	7/2/2021	14
16	8/2/2021	15
17	9/2/2021	16
18	10/2/2021	17
19	11/2/2021	18
20	12/2/2021	19
21	31/1/2021	20
Sheet1

Cell Formulas
Range	Formula
N2:N21	N2	=IFERROR(INDEX($B$2:$B$21, SMALL(IF(TODAY()-1=$A$2:$A$21, ROW($A$2:$A$21)-ROW($A$2)+1), ROW(1:1))),"" )
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Kingchaos64]

I think that would work but sometimes there's 20 busses and there numbers are like 8668,8868,8686 and so on, it gets really confusing. So its helpful for me to look and just see one thats not highlighted. Not sure why the owner or the state signed off on numbers like this but it's not helpful to employees or passengers.
Thanks for all your help Zoe. If I could give two solution credits I would. I just have to go with the one solution that I'm going to be using.

 

[Zot]

I think that would work but sometimes there's 20 busses and there numbers are like 8668,8868,8686 and so on, it gets really confusing. So its helpful for me to look and just see one thats not highlighted. Not sure why the owner or the state signed off on numbers like this but it's not helpful to employees or passengers.
Thanks for all your help Zoe. If I could give two solution credits I would. I just have to go with the one solution that I'm going to be using.

True. If you are looking at numbers like that they end up look the same before end of day. Highlight helps a lot ?