VBA format cell based on vaslue in another cells

[Access Beginner]

Hello All,

I'm using an index and match (in cell G8 on the ISS_Charts sheet) to return the value based off cells in C1 and D3, copied down and accross so next match will be for C2 and D4 and so on.

My issue is that depending on what is in C1..C15 the number fromat will change. As an example the value in C1 could be T1.1 and the format should be a percentage. However based on a selection (drop down list), the value of C1
could be T1.2 and the format of this should be currency.
Below is a table of the values and the formats I'd like applied.



T1.1 - Percentage
T1.2 - Percentage
T1.3 - Percentage
T1.4 - Currency
T1.5 - Percentage
T2.1 - Number (no decimals)
T2.2 - Number (no decimals)
T2.3 - Number (no decimals)
T2.4 - Percentage
T2.5 - Percentage
T2.6 - Currency
T3.1 - Currency
T3.2 - Percentage
T3.3 - Percentage
T3.4 - Percentage
T3.5 - Number (no decimals)
T3.6 - Percentage

Any help is appreciated.