View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
viraj
 
Posts: n/a
Default How to give function by cell color to sum two value in Excel

A B
1 x 3
2 y 2
3 z 4

If I fill color (Red) B1 and B3 then I should get the sum of B1 and B3.
How this function can be made in excel with the property of cell?