View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to write a formula to set the Font Style?

Does anyone know how to write a formula to set the Font Style based on the
text language under specific cells?

For example, in cell A1, there is some english text, then I would like to
use the font "Arial" with size 8. However, if there is some chinese text in
cell A1, then I would like to use font "XYZ" with size 15.
Does anyone have any suggestions on how to write a formula to determine the
text in order to set the text styles?
Thank you for any suggestions
Eric