Conditional Format searching for date

%3CLINGO-SUB%20id%3D%22lingo-sub-2883081%22%20slang%3D%22en-US%22%3EConditional%20Format%20searching%20for%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2883081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hai_ng0212_0-1635186595514.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319831i7202C838E40607C8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hai_ng0212_0-1635186595514.png%22%20alt%3D%22hai_ng0212_0-1635186595514.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ei%20have%202%20date%20value%20in%20excel%20show%20as%20screen%20capture%20%2C%20can%20i%20use%20conditional%20format%20if%20anything%20%22%2010%2F25%2F2021%22%20.%20Cell%20set%20format%20as%20%22Date%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2883081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2883123%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Format%20searching%20for%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2883123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1187988%22%20target%3D%22_blank%22%3E%40hai_ng0212%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DD7%3D%2210%2F25%2F2021%22%3C%2FP%3E%3CP%3EApply%20this%20rule%20for%20conditional%20formatting.%20Please%20compare%20attached%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hai_ng0212_0-1635186595514.png

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

@hai_ng0212 

=D7="10/25/2021"

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

@hai_ng0212 

I missed that unfortunately. Please try this rule:

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

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