Auto align depending on certain text

[mfengineer]

Hi

I am working on a spreadsheet where I select a option from a dropdown list and I am hoping to find a way for certain words to auto align on the right rather than the left.
I have had a play but cannot find a way to get this working.

In the attached spreadsheet I would like the options Part, Scrap and Packaging to align on the right, all other selections I would like to keep aligning on the left.

Over time I would like to be able to add words to the dropdown list and select which ones I want on the left and which on the right.

If anyone can help I would be very grateful.