View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Israel Israel is offline
external usenet poster
 
Posts: 47
Default add total only shaded cells

Hi everybody,

Can anyone help.
I have a formula that colors the cell which is less, how can I add only the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula
to highlight with a color the <cell. Is there a way to add the value of the
colored cell only?

Please help!
--
smile