Скачать или смотреть excel group column highlight matching values

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah  

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!excel group column highlight matching values

I have a alphabetized dataset of:
D47058V212B 9/23/2024 20:56
D47058V214 9/23/2024 20:56
D47058V29 9/23/2024 20:57
D47065V24 9/23/2024 23:02
D47089V215A 9/23/2024 23:37
D47091V214 9/23/2024 23:40
D4712426 9/24/2024 0:29
D47138V28 9/23/2024 22:52
D5485911 9/24/2024 3:39

D47058V212B 9/23/2024 20:56
D47058V214 9/23/2024 20:56
D47058V29 9/23/2024 20:57
D47065V24 9/23/2024 23:02
D47089V215A 9/23/2024 23:37
D47091V214 9/23/2024 23:40
D4712426 9/24/2024 0:29
D47138V28 9/23/2024 22:52
D5485911 9/24/2024 3:39

I'd like to have each group by the first 6 matching characters. So all the values that start with D47089 are blue highlighted. all the D47091 are green highlighted ect. Having it rotate between 3 different colors all the way down the column. (colors aren't important, just that they rotate for easy reading).
D47089
D47091
Is there a way to have excel do this automatically without me having to create separate conditional rules for each possible iteration of the first 6 characters?


Tags: excel,excel-formulaSource of the question:
https://stackoverflow.com/questions/7...

Question and source license information:
https://meta.stackexchange.com/help/l...
https://stackoverflow.com/