| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro -find all occurences of a word-change color of cell of all
I need help!
I need a macro to find all occurences of the word "Count" in Column B, and then change the fill color for all the cells located to Yellow. Could someone help me with the proper procedure to do this. Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro -find all occurences of a word-change color of cell of all
Hi Lost in Alabama,
See the example given in VBA help for the FindNext method. --- Regards, Norman "Lost in Alabama" wrote in message ... I need help! I need a macro to find all occurences of the word "Count" in Column B, and then change the fill color for all the cells located to Yellow. Could someone help me with the proper procedure to do this. Thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro -find all occurences of a word-change color of cell of a
Hello....This is your Sign!! Thank you so much for the help and I pray you
have a Blessed Year! Lost in Alabama "Norman Jones" wrote: Hi Lost in Alabama, See the example given in VBA help for the FindNext method. --- Regards, Norman "Lost in Alabama" wrote in message ... I need help! I need a macro to find all occurences of the word "Count" in Column B, and then change the fill color for all the cells located to Yellow. Could someone help me with the proper procedure to do this. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the color the cell becomes when doing a FIND | Excel Discussion (Misc queries) | |||
| EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD? | Excel Worksheet Functions | |||
| Find purple cell color, change to red | Excel Programming | |||
| Find purple cell color, change to red | Excel Programming | |||
| find word in a cell then change cell format | Excel Programming | |||
Hybrid Mode
