Align the conditional formatting icon to the right of the text (MACRO?)

Hi there,

I'm sure this is not a new question, but using arrows or traffic lights & text in a cell means a left alignment of the icon in the cell.

This is causing some confusion as the ICON looks like it is associated with the column previous, not the actual cell.

Our need means that we cannot have 'another' column for the icons and needs to appear in the same cell.

Has anyone discovered a way to achieve this or is there a MACRO or similar/VB that could be used to achieve this visual display?

CHeers.