Conditional find

[Ramesh]

Hi,

I have used the conditional formatting. I was wondering if there is a way
to do a conditional find. By using Ctrl F, is there a way I can search the
spreadsheet values based on a condition instead of a specific value.

For ex, I want to find the values that exceed say 10 using ctrl+F in a
particular column or a selected bunch of cells.
Is there an alternative ?

Thanks,
Ramesh.

 

[Damon Ostrander]

Hi Ramesh,

It would be easy to write a VBA macro that would do this.
But are you willing to entertain a VBA-based solution?

If so, you would probably want to assign a keyboard
shortcut other than Ctrl-F so that it would not be
confused with the built-in Find.

Damon

mailto:[email protected]