View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrlanier@hotmail.com is offline
external usenet poster
 
Posts: 63
Default 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