Please help me and you will be blessed.

[seanexcels]

Hi all,

I am new to Excel and have a question. What I am wanting to create is an if/then formula that when you enter a number from 1 to 9, the whole row the cell is in gets shaded red or some other colour. Any help would be much appreciated. Please help and you will receive good karma.

Cheers,

Sean

[mudraker]

Have a look at conditional formatting which is under the Format menu

[seanexcels]

Thanks for the quick reply. I appreciate it. I have been trying all night and then I just figured out the formula. Now if I can just figure out how to date stamp and add a clock in my spreadsheet i will be finished. the date stamp i need is when i edit a row, the date stamp will change to show the date the cell or row was edited.

[mudraker]

The only way to do a date stamp so that it does not change when the sheet recalculates is to manual enter the deatails in the required cell or with a Worksheet change event macro.

To build a macro you will need to supply details of what rows or columns or range of cells the macro needs to monitor. Where does the macro put the date stamp .

Example Worksheet change macro
you change entry in any columns from a to e the date stamp goes into column f of the same row.

To install macro to correct location

Copy this macro
GoTo Excel
Select sheet this is to appy to
Right Click on Sheet Name Tab > select View Code
Past macro into the Worksheet Module displayed
Return to Excel & try entering data into any cell in column a to e

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim Rng As Range

   For Each Rng In Target
      Select Case Rng.Column
      Case 1 To 5
         Application.EnableEvents = False
         Cells(Rng.Row, "f").Value = Now()
      End Select
   Next Rng
   Application.EnableEvents = True
End Sub