Conditional Formatting Font size

I want to change Font Size ,when Conditional formatting is used in a range.

I know , it is not possible with conditional formatting basic application.

I need a macro code, if possible to do it.

In attached file, you can see the detail and what is wnated.

Thanks in advance for any reply and help.ç

Regards,
turist

Originally Posted by MarvinP

Hi,

See if this VBA code works for you. Change any of the values in column A and the Max(s) will go to 24 font size. Look at the VBA code behind the sheet for the EVENT code and in the Module for the code to make the font size bigger.

Dear MarvinP

Thanks for very helpful reply.
Great, works.

Regards with rep.
turist

Originally Posted by MarvinP

Hi,

See if this VBA code works for you. Change any of the values in column A and the Max(s) will go to 24 font size. Look at the VBA code behind the sheet for the EVENT code and in the Module for the code to make the font size bigger.

Hello! MarvinP This is such another info for me. Thanks for posting the attached files with the VBA code.