Hi, just a quick question..

say a user enters a number in a cell how would i be able to get all cells that contained that number to be highlighted?


you want it to be highlighted so you can get the sum or what? if you just want to get the sum let's say user enter number from rows a1:a3, at row a4.. click of the formula button and choose the sum formula..or you can enter the formula manually such as: =SUM(A1:A3).

but if you just want to highlight then you can use this macro. hope it helps ;)

Sub Macro1()
' Macro1 Macro
' Macro recorded 11/27/2009 by cguan_77

Dim Lastrow, i As Integer

Lastrow = ActiveSheet.UsedRange.Rows.Count
 For i = 1 To Lastrow
    Cells(i, 1).Select
    With Selection.Interior
        .ColorIndex = 5
        .Pattern = xlSolid
    End With
End Sub

I managed to resolve the problem with an online tutorial I found but thanks for the reply anyway :)

I have another question if some one could help me How the filters works in the Excel. Can some one help me in this case?

I might be able to help, but I would need a more specific question.