macro -find all occurences of a word-change color of cell of all

G

Guest

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,
 
N

Norman Jones

Hi Lost in Alabama,

See the example given in VBA help for the FindNext method.
 
G

Guest

Hello....This is your Sign!! Thank you so much for the help and I pray you
have a Blessed Year!

Lost in Alabama
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Remove Hyperlinks Without Changing background shading 14
Macro to change color of tab based on color of cell 5
Excel Macro to automatically go to the right of the last colored cell 0
change font color for cells starting with "T " 3
Counting occurences of text string in a text file 1
counting occurences of cell matches 1
GridLines Inadvertantly Goes Away with Macro 3

Top