Did u know - Excel

1. To add only the colored cells in excel add the following coding in the macro window:

Function sumcolor(selcel As Range)
  Dim Cell As Object
  Dim x As Double
  x = 0
 
  For Each Cell In selcel
      If Cell.Interior.ColorIndex = -4142 Or Cell.Interior.ColorIndex = 2 Then
      Else
         x = x + Cell.Value
      End If
   Next Cell
   sumcolor = x

End Function

An Example:
-Google Docs
-Mediafire Link

----------------------------------------------------------------------------------------------------

2. Display Amount in Indian Rupees Format, i.e., in Crores in Excel.

• Select the desired cells
• Press Ctrl + 1
• Select Custom Number format
• Paste this in the 'Type:' textbox -  [>=10000000]##","##","##","##0.00;[>=100000]##","##","##0.00;#,##0.00

-----------------------------------------------------------------------------------------------------