How do I do conditional formatting with today's date, but which also includes other text?

[Chancewouldbeafinething]

Hi guys,

I've been trying to find a way to adopt conditional formatting for a cell which contains today's date. I've been able to do this successfully, but if I include other text in the cell (for example, a time - see image attached), the conditional formatting does not work.

What would be the way around this? Does anyone know of a formula?

Many thanks

 

[SanjayGMusafir]

What I found from the screenshot is that the cell with current date contains date and what we are searching for is a text. Try adding some time to it and then check.

 

[Chancewouldbeafinething]

What I found from the screenshot is that the cell with current date contains date and what we are searching for is a text. Try adding some time to it and then check.

Thanks! I see what you mean about text, but when I turn the dates into text format, they come up like '45239' instead of 15/11/2023, for example?

 

[SanjayGMusafir]

Check as below, particularly Cell L7, the solution is in cell L8

Book1
	J	K	L	M	N
1
2
3
4			23/11/23 @ 10:40
5			24/11/23 @15:57
6			17/11/23 @ 10:45
7			11/17/23
8			17/11/23 @ 00:00
9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L:L	Expression	=FIND(TEXT(TODAY(),"dd/mm/yy"),L1)	text	NO

 

[Chancewouldbeafinething]

Check as below, particularly Cell L7, the solution is in cell L8

Book1
	J	K	L	M	N
1
2
3
4			23/11/23 @ 10:40
5			24/11/23 @15:57
6			17/11/23 @ 10:45
7			11/17/23
8			17/11/23 @ 00:00
9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L:L	Expression	=FIND(TEXT(TODAY(),"dd/mm/yy"),L1)	text	NO

I think I'm nearly there, but now it seems as though the wrong date gets highlighted?

 

[SanjayGMusafir]

though the wrong date gets highlighted?

Use L1 not L13 in formula

 

[Chancewouldbeafinething]

Check as below, particularly Cell L7, the solution is in cell L8

Book1
	J	K	L	M	N
1
2
3
4			23/11/23 @ 10:40
5			24/11/23 @15:57
6			17/11/23 @ 10:45
7			11/17/23
8			17/11/23 @ 00:00
9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L:L	Expression	=FIND(TEXT(TODAY(),"dd/mm/yy"),L1)	text	NO

It's worked! Thanks so much for your persistence and patience

P.s: could you tell me why it had to be L1 and not L13 in the formula?

 

[SanjayGMusafir]

could you tell me why it had to be L1

When we are formatting, we refer first cell of the range. Rest system takes automatically.