Color in worksheet

[Annebee]

I have created several spreadsheets each showing months of the year, what I would like to do is if there is a number in a cell on the previous month fill in the cell with a royal blue color on the current month.
For instance:
Columns are items such as books, lunch, paper, etc
Rows are names of people.
so if John received 2 books in January then the cell for his name under books in january would be filled with blue color.

Thank you for your help

 

[tropix100]

You could try using Conditional Formatting for such a situation.

Visit here and see if it helps you.
http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html

 

[Annebee]

Thank you tropix, I did try that, one problem I was getting a message stating you cannot use conditional formating between worksheets.

Any other ideas.

Thanks
Anne

 

[tropix100]

How about adding something like

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Range(Target.Address).Value <> "" Then
        Sheets(Sh.Index + 1).Range(Target.Address).Interior.Color = vbBlue
    End If
End Sub

This will assume you always have another sheet after the one you are entering data into.
It should be a good start.