basic option not possible? conditional formatting to change font in cel with arab name

[littlepete]

hello all

Am i mistaken or is it not possible to change the font of a cel, containing an arab name, written in arab, to a more beautiful font?

i can change background, text color, bold, anything else is possible, but the font list stays untouchable...

what can i do?

all enjoy the start of the advent !

 

[dave3009]

Hi Peter

You can't change the font family using conditional formatting regardless of which language is in use.

 

[littlepete]

Hi Peter

You can't change the font family using conditional formatting regardless of which language is in use.

hello

that is what i sadly expected... could i use a formula to change the font of a cell if there is arab text in it?
i have a column bm that tells me which script is used, one of them being arab...

vba is the only thing i know, but not possible here...

have a nice weekend !

 

[Michael M]

@littlepete
I don't know if this helps, but by detecting the cell contains Arabic, will let you make changes by VBA
HAve a look here

Detect Cells that have arabic text using VBA

Hello All, How can we highlight cells that has arabic text in excel sheet, how can we implement that using VBA.

www.mrexcel.com

In particular Post #7

 

[littlepete]

@littlepete
I don't know if this helps, but by detecting the cell contains Arabic, will let you make changes by VBA
HAve a look here

Detect Cells that have arabic text using VBA

Hello All, How can we highlight cells that has arabic text in excel sheet, how can we implement that using VBA.

www.mrexcel.com

In particular Post #7

hello

thank you very much !
i do know how to check for arab with vba but i need a formula or conditional formatting, i already understood conditional formatting for a font is impossible... thanks for the tip !!!