Conditional Formatting by URL

Hi Guys,

I'm trying to do conditional formatting by URL for one of my column in my report.

I've different URLs for all different Source types like 

For Supplier : https://abc.energy/broker/deal/detail

For Consulting : https://abc.energy/broker/Consulting/detail

How can I do the formatting for each Source Type? I tried creating a custom column and using URL and & function but it is returning same URL for each source type and I want seperate URLs.

I have already created a URL for Customer and that is fine but for Deal I need seperate URL as stated above.

Is there any possibility for this?

P.S : I have unique ID for each row in the table.

Regards,

Himanshu