View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S Isfeld S Isfeld is offline
external usenet poster
 
Posts: 4
Default Force recalcualte on cell format change

Need to force Excel to recalculate when the user changes the font color or
fill of a cell within the worksheet. Have a custom function the counts the
number of cells with a cetain fill or font color. Function recalcutales if
the data in the range is changed but not on a chang to the font or fill
color. How can I get Excel to recalculate on a change to the cell format?