SOLVED

Searching TODAY()

Copper 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)
Solution

@Veijo_Vuorela 

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

Thanks
You understood just right. I think I thought over too complicated.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Veijo_Vuorela 

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

View solution in original post