Conditional find
 

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.

Conditional find
 

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




-----Original Message-----
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.
.