I want all rows which say either ADULT SWIM, BET, COMEDY, MTV, NBC, TBS, or VH1 to be highlighted in light grey and also have all content in the row bolded. All using VBA. Thanks!!
I want all rows which say either ADULT SWIM, BET, COMEDY, MTV, NBC, TBS, or VH1 to be highlighted in light grey and also have all content in the row bolded. All using VBA. Thanks!!
I can't seem to find any of the words you mentioned.
The words are in column B. Not all of them are in there, but some of them are, such as NBC and VH1.
The macro should look through column B to find the words.
This should do, but I do not know the color of grey, so used red instead
![]()
Please Login or Register to view this content.
Last edited by AB33; 02-15-2013 at 06:37 PM.
Thank you so much, but is there a way to make it highlight and bold the entire table's row if its cell in column B has one of those certain words?
You mean the entire row
Change these two lines of the code
INTO![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
I meant the entire row of the table. So, I would like the first four cells of the row to be highlighted and bolded. Is that possible?
"first four cells of the row to be highlighted and bolded"
How? The searched items on not in consective order. For e.g, if the code finds MTV in row 40, how do you want to be highlighted the entire table.
Or, do you mean when the search finds MTV, you need to highlight 4 rows. Please explain.
I am sorry that I'm not good at explaining things. I would like for the rows being highlighted to only go from cell A to cell D instead of the row going on forever.
So,instead of the enitre row, you want to highlight from A-D, once a search is find in column B. is this right? See amended code no 4.
Last edited by AB33; 02-15-2013 at 06:38 PM.
Try this:
![]()
Please Login or Register to view this content.
Last edited by PushCar; 02-15-2013 at 07:01 PM.
Pushcar,
Please use code tags with your code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks