Conditional Format searching for date

[hai_ng0212]

i have 2 date value in excel show as screen capture , can i use conditional format if anything " 10/25/2021" . Cell set format as "Date".

[#2]

@hai_ng0212 

=D7="10/25/2021"

Apply this rule for conditional formatting. Please compare attached file.

[#3]

i have both Date in the same cell . 10/15/2021 and 10/25/2021 so =D7="10/25/2021" wont work

[#4 · Accepted solution]

@hai_ng0212 

I missed that unfortunately. Please try this rule:

=ISNUMBER(SEARCH("10/25/2021",C4))

[#5]

Thanks it is working , i modified the function : =ISNUMBER(SEARCH(TEXT(TODAY()+1,"mm/dd/yyyy"),H2)) and i worked well .
Thanks Again