Conditional Format searching for date

Occasional Contributor


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".

4 Replies



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

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


I missed that unfortunately. Please try this rule:


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