Hello everyone,
Thank you for your time. I am very new to VBA. Any possible help I could get will be extremely useful. In a worksheet, I have data from D11: E252. Each cell contains a string of text. I want a macro code that will change the font colour of first occurance.
Last edited by Lona; 09-24-2021 at 04:08 AM.
Can you clarify your question?
Why should "apple" be changed to red? If it is mentioned 2 times, it is not unique in the sheet. Same for almost everything else in your list. "Purple" is the only word that is unique in the sheet.the words font colours that should be changed to red are apple (only once; however in the table it is mentioned 2 times)
This assumes that words are separated by a single space and that you're using Windows OS. If this is not the case then a more complex solution would be required:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
Hi 6StringJazzer,
Thank you for your reply.
May be "Unique" was not the right way to phrase it. There are repetitive words in the sheet, I want those words to be highlighted only once (i.e, font colour for the words in red) + the unique words. Please note each cell contains multiple words separated by spaces. I have attached the excel with a very little sample data with the expected outcome in first sheet & original data in second sheet, please let me know if you need a better sample sheet.
Thank you the code worked perfectly well.
Last edited by Lona; 09-23-2021 at 09:56 AM.
HI,
I have one follow-up question to the above code. I want the code to work only on the filtered data (visible cells at the time the macro is run). When I run this macro while there is some filtered data, it is highlighting for the entire sheet (non-visible cells as well). Is it possible show first occurrence only for the filtered data ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks