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]

Check this and revert -

Book1
	A	B	C
2
3		15/11/23 @ 14:45
4
5
Sheet1

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

 

[Chancewouldbeafinething]

Check this and revert -

Book1
	A	B	C
2
3		15/11/23 @ 14:45
4
5
Sheet1

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

Like this? (cell I've chosen is L19)

 

[Chancewouldbeafinething]

Ignore the extra '3' at the end, that was my error

 

[SanjayGMusafir]

Like this?

Use this for column L:L. Try and revert -

=FIND(TEXT(TODAY(),"dd/mm/yy"),L1)

 

[Chancewouldbeafinething]

Use this for column L:L. Try and revert -

=FIND(TEXT(TODAY(),"dd/mm/yy"),L1)

Sorry, still having a few issues : 15/11/2023 should have lit up but doesn't appear to be

 

[SanjayGMusafir]

It's working, I just checked. Check as below -

Book3
	K	L	M	N
1
2
3
4		23/11/23 @ 10:40
5		24/11/23 @15:57
6		15/11/23 @ 10:45
7
8
9
10
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]

It's working, I just checked. Check as below -

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

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

Must be something wrong my end - I'll have a play and come back Thanks so much for your help!

 

[SanjayGMusafir]

Must be something wrong my end

actually the current date cell is not completely visible in the screenshot you shared

Moreover if you can share XL2BB I can help you look for errors if any

At time the order of rules can also cause error - You can check that too

 

[Chancewouldbeafinething]

actually the current date cell is not completely visible in the screenshot you shared

Moreover if you can share XL2BB I can help you look for errors if any

At time the order of rules can also cause error - You can check that too

No problems - does this image show it clearer?