Can anyone help me.

Im trying to write a macro where each time i enter text in column A it
will conditionally format the number in the same row of column C ?

The text that is entered in column A is limited to the list below.



column A(TEXT) column C(format)

ES (####.##)
NQ (####.##)
AB (####.##)
YM (####.##)
ZB (# #/32)
EC (#.####)
JY (###.##)
ED (##.###)