Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

Once the cells are found (Selected)

Format Cells Patterns and then click a background color
--
Gary''s Student
gsnu200710


"dford" wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

Is there a way to automatically fill the cell that is forun without having to
format. I'm trying to find a way to make the cell stand out once it is found.

"Gary''s Student" wrote:

Once the cells are found (Selected)

Format Cells Patterns and then click a background color
--
Gary''s Student
gsnu200710


"dford" wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

dford

Not without using VBA.

Sub find_and_color()
Dim rCell As Range
Dim whatwant As String
whatwant = InputBox("enter criteria. e.g dford or *for*")
Range("A1").Select
For Each rCell In ActiveSheet.UsedRange
If rCell.Value Like whatwant Then
rCell.Interior.ColorIndex = 6
End If
Next rCell
End Sub


Gord Dibben MS Excel MVP

On Sun, 11 Mar 2007 11:27:05 -0700, dford
wrote:

Is there a way to automatically fill the cell that is forun without having to
format. I'm trying to find a way to make the cell stand out once it is found.

"Gary''s Student" wrote:

Once the cells are found (Selected)

Format Cells Patterns and then click a background color
--
Gary''s Student
gsnu200710


"dford" wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

Or maybe this ? with Find
http://www.rondebruin.nl/find.htm#worksheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
dford

Not without using VBA.

Sub find_and_color()
Dim rCell As Range
Dim whatwant As String
whatwant = InputBox("enter criteria. e.g dford or *for*")
Range("A1").Select
For Each rCell In ActiveSheet.UsedRange
If rCell.Value Like whatwant Then
rCell.Interior.ColorIndex = 6
End If
Next rCell
End Sub


Gord Dibben MS Excel MVP

On Sun, 11 Mar 2007 11:27:05 -0700, dford
wrote:

Is there a way to automatically fill the cell that is forun without having to
format. I'm trying to find a way to make the cell stand out once it is found.

"Gary''s Student" wrote:

Once the cells are found (Selected)

Format Cells Patterns and then click a background color
--
Gary''s Student
gsnu200710


"dford" wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

If you're using xl2002+ or higher, you can use Edit|Replace and specify a format
for the "to" string.

Just replace a string with the same string and use that option to change the
format (on the pattern tab).

dford wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

--

Dave Peterson

I always forget that option Dave
Thanks for posting it

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
If you're using xl2002+ or higher, you can use Edit|Replace and specify a format
for the "to" string.

Just replace a string with the same string and use that option to change the
format (on the pattern tab).

dford wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

--

Dave Peterson

Worked great Dave. Thanks for the help.

"Dave Peterson" wrote:

If you're using xl2002+ or higher, you can use Edit|Replace and specify a format
for the "to" string.

Just replace a string with the same string and use that option to change the
format (on the pattern tab).

dford wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?

--

Dave Peterson

Neat trick!

Gord

On Sun, 11 Mar 2007 15:19:38 -0500, Dave Peterson
wrote:

If you're using xl2002+ or higher, you can use Edit|Replace and specify a format
for the "to" string.

Just replace a string with the same string and use that option to change the
format (on the pattern tab).

dford wrote:

Using the find feature, is there a way to automatically fill the cells with a
color that are found rather than just having the cells selected?