Forum Discussion
chrisp
Jul 27, 2017Copper Contributor
Formulas to change font types
Greetings, GentleBeings!
I use an Excel spreadsheel to mail-merge to a MS Word form letter.
The form letter is "signed" by three different people, by using a form field to display the name of the signee, merged from the Excel spreadsheet.
I would like the font to be different for each signee.
Does anyone know how to write a formula to change the font depending on the name?
The conditional formatting commands will not allow me to change the font type, but only the Bold, Italic, etc...
Any help on this would be lovely!!!
1 Reply
- SergeiBaklanDiamond Contributor
Hi Chris,
You need to write your own conditional formatting using VBA, the answer is here https://excel.tips.net/T002380_Changing_Font_Face_and_Size_Conditionally.html