Thread: I'm looking to add cells (that are formated in %) in them.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j5b9721 j5b9721 is offline
external usenet poster
  
Posts: 63
Default I'm looking to add cells (that are formated in %) in them.
a1 has 10%
a2 has 30%
a3 has 10%
a4 has 20%
a5 has 5%
a6 has 15%
a7 has 10%

a8 needs to be ONLY "100%" total the above percentages or default to red in
color if below 100%
Reply With QuoteReply With Quote