How to set transparency in Excel macro

[RonPar]

I want to highlight cell data with a semi transparent back color to leave the cell data more visible. Tried using standard black data, both normal and bold, over a cyan background but the background is too saturated to make reading the data easy. Having trouble finding a reference to lead me to a solution.

[SioSio]

The background color cannot be transparent.
Choose a bright background color.
Another alternative is to paste a cyan image of the same size as the cell into the foreground to make it transparent.