Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
How do I find blank cells using AutoFilter's Custom feature? | Excel Worksheet Functions |