Formula for Marlett font

[priyankasanjay]

Hi,

Generic drug Column A and
[TABLE="width: 377"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 377"]
<tbody>[TR]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]aceclofenac + paracetamol

[TABLE="width: 223"]
<tbody>[TR]
[TD]acipimox[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Combination Column B- In column B I should have automated pop up of marlett font x for single drug and tick for drugs with + sign.

Please help me.
Regards
Priyanka

 

[mole999]

if you can guarantee that only a single word would relate to a drug then you could code for that in VBA example Aspirin would be Martlett, but Acetylsalicylic Acid wouldn't

How do you envisage the tick would be applied to the sheet, what process would be followed and consistant