• 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


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

Can I use conditional formatting to change the font size based on the value of a cell?


New Member
I am trying to set up conditional formatting to change the font to a bigger number based on the highlighted value. However, the font size is not available, it is greyed out. Is there another way to accomplish this without using VBA? In the worksheet could I use an if() statement to change the font size????



Excel Ninja
Staff member
Conditional Formatting is setup so that it cannot change the layout of a worksheet
Changing the font size will cause rows to change size which breaks that rule