Is it possible to generate VBA code for conditional formatting of font type? If not is there any suggestion of third party code to perform this function.
Conditional Formatting (CF) does not allow the font style or size to change as part of the CF process
This is so that the basic underlying structure and layout of the worksheet does not get altered by the CF
You could imagine that if a CF format was set to change a 10 pt font to a 100 pt font if A1=1 the every time A1 = 1 the cells subject to the CF would change and the columns that they are in would change size. This creates havoc for the layout of the worksheet and so isn't allowed. Changing the font triggers a similar change in cell/column size.
You can do this by using VBA using a Change event and some simple VBA as long as you are aware of the possible consequences
I'd suggest posting a sample file and highlight the areas you want to have change