Searching TODAY()

New Contributor

I have function TODAY() in cell L5. Then I have column F containing dates. How do I find L5's value from the column F?

Using Conditional Formatting helped a bit, but it didn't show the selection as the Find and Replace does.

2 Replies
best response confirmed by Hans Vogelaar (MVP)


Not sure I understood what exactly you'd like to do. Search works - Ctrl+C cell L5, Ctrl+F, Ctrl+V value into the bar, Find next

You understood just right. I think I thought over too complicated.