conditional formating problem

[spudgun44]

I want to enter a letter into a cell (based on traffic lights R,A,G)

but then I want that cell to display a smiley (green - happy, amber - straight mouth, and red unhappy)

in addition to this I would like the smileys to be the same colour as the letter entred

is this possible? I have tried it but keep coming accross circular formula errors

Thanks

 

[Upex]

Glad it worked for you Spudgun44. Any issues post back and I'm sure we'll sort it.

Upex.