• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code for conditional formatting of font type

Jazerous

New Member
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
 
Back
Top