View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C John C is offline
external usenet poster
 
Posts: 7
Default .FontSize conditionally

I have cells that are conditionally formatted as follows:
=$D6=VLOOKUP($B6,irr_goals,2)
Bold, Underline


I want these cells to increase the fontsize to 10 under the same conditions.
Does anybody know why Microsoft has the Font option Greeked out??

Even more important, can somebody tell me how to make this work...I know
there is a .fontsize parameter in code so it stands to reason that this can
be done, but I don't know VBScript.

Please Help