Automatically change sheet tab color based on sheet name

Hi there!

I've created a web automation that scrapes flight data from the web and stores it into an Excel doc. It automatically creates a new sheet for each flight search I have it perform. It renames each sheet based on the departure/arrival location and the date of the flights I'm searching for (Example sheet names: "DC-NY | 9-14-23" or "NY-DC | 9-15-23").

I only search for flights between these two destinations. I'm trying to create a Macro that automatically changes the color of each new tab created for flights from DC-NY to Red and all flights from NY-DC to Blue. Basically I need the Macro to change the color of the tab based only on the first part of the sheet name and ignore the date also included in the name because that date changes with each new sheet that gets created.

Hope I was able to explain that clearly enough. Any help would be greatly appreciated!

Thanks!

something like:

Please Login or Register  to view this content.