Oct 25 2021 11:31 AM
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".
Oct 25 2021 11:45 AM
=D7="10/25/2021"
Apply this rule for conditional formatting. Please compare attached file.
Oct 25 2021 12:39 PM
Oct 25 2021 02:21 PM
SolutionOct 25 2021 02:47 PM
Oct 25 2021 02:21 PM
SolutionI missed that unfortunately. Please try this rule:
=ISNUMBER(SEARCH("10/25/2021",C4))