Search should highlight entire row in Excell in red
 

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.

You could write a macro to do this.

--
Don Guillett
SalesAid Software

"samuel" wrote in message
...
When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire
row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.

I am not sure how to write a macro, I thought this was a suggestions place.

"Gord Dibben" wrote:

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.

Hi

I have a sample worksheet that will get you started. Email me and I will
send it to you.

HTH

Ken

Samuel

I have not seen a question in your post(s).

I assumed you were only making a suggestion on how to improve the Find
feature.

Gord

On Mon, 27 Dec 2004 13:43:06 -0800, samuel
wrote:

I am not sure how to write a macro, I thought this was a suggestions place.

"Gord Dibben" wrote:

Samuel

If you think you have the ear of an Excel developer, think again.

Just us people like yourself here.

To possibly have this feature added to the next version of Excel.........

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Mon, 27 Dec 2004 10:33:01 -0800, samuel
wrote:

When searching for something, often the object found is in a filed amongst
thousands of others. Relevent information is often along side the entire row.
It is easier to scroll and view what you will from the entire row, if
highlighted.

A tickbox in the search window should allow for either the entire row,
column, both or neither to be highlighted (and choice of colour).

Like searching in the Mozilla browser, the word is highlighted, often
inverted.