View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith Bliss Keith Bliss is offline
external usenet poster
 
Posts: 3
Default Summing cells which are flagged in some way

Hi
I have a series of budget figures in a row. Some of thes are committed and
some are not. I want to sum only those which are committed. Can I do this by
text colour or some other flag. I have read some other posts with VB code for
colour text functions but dont know how to implement them. Is there an easier
way?
Thanks for looking
Keith