Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default Find feature - Fill cells with color

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Find feature - Fill cells with color

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default Find feature - Fill cells with color

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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Find feature - Fill cells with color

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?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Find feature - Fill cells with color

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?




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Find feature - Fill cells with color

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
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Find feature - Fill cells with color

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

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default Find feature - Fill cells with color

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

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Find feature - Fill cells with color

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill cells with color based on criteria in two cells AA Excel Worksheet Functions 2 January 3rd 06 12:29 AM
The fill feature in Excel that gives option to fill or copy KAHelman New Users to Excel 1 July 29th 05 08:47 PM
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 05:38 PM
My excel 2003 wont let me fill cells with color or color the tabs. trizog New Users to Excel 2 February 22nd 05 07:43 PM
How do I find blank cells using AutoFilter's Custom feature? Andrea Blake Excel Worksheet Functions 2 November 30th 04 10:03 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"