Conditional Change of Font Size

[svaiskau]

Using traditional Conditional Formatting will not allow you to change font size. I want to set a series of cells to lower their font size to Arial 9 if the value is between 100 and 999, and to Arial 7 if the value is greater than 999.

Arial is the default font face, so that isn't changing at all.

[T-J]

This will set the font size of cells in the range A1:C5 on sheet1:

Please Login or Register  to view this content.