Conditional formatting in VBA dependent on the text string in adjacent cell.

[KHurley]

Hi. If someone can please give me some advice, that will be grand.

D7:D16 say either "POUND", "PERCENTAGE", OR 'NUMBER'.

E7:E16 say a number ranging between 0.01 and 10000000

I effectively want to code in VBA so that E7:E16 will be formatted corresponding to the adjacent text string.

So, if D9 says "POUND", E9 will be formatted as £X etc etc.

I tried to record a macro to advise myself to no avail. It did spit out:

.NumberFormat = "$#,##0"
.NumberFormat = "0"
.NumberFormat = "0%".

Which wasn't very helpful.

I've called the private sub:
conditional_formatting_summary ()

The tab in question is called "control dashboard"

Thank you

Kevin

End sub

 

[KHurley]

Hello - I have quite simply just formatted before running the Macro. My apologies for such a lame post!