Change size of font if cell value is greater than 0
I would like to change the size of font in a merged cell when the
value of a different cell is greater than 0. For example, if A10,
then the font in B1 (merged cells B1:D1) will change from a default of
8 to 12, and revert back to 8 when A1=0. Are there any suggestions
for a macro. Thanks in advance.
Michael
|