Hi,
I have a list of values on sheet 1 from A1 to A100.
A1 - 45555ac
A2 - 4555AX
A3 - 30052V
A4 - 28852A
and so on...
My workbook has around 300 work sheets. I want to highlight (green color) the sheet (tab) color which have the names listed from cells A1 to A100 in sheet 1.
Can anyone please help me with VBA here? I did look into lot of other threads but could not find one.
Thank you.
What needs to match your list? the tab name?
This will color the tab green, just need to add the logic to check
Please Login or Register to view this content.
If you find the suggestion or solution helpful, please consider adding reputation to the post.
Possibly...Please Login or Register to view this content.
Attachment 736212
Please see the image. based on the list in sheet 1, I want to highlight the tabs in green color
Thank you very much! It works great
Here is a working example with the macro looking at the names
Thank you!! Perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks