VBA amateur looking for some tips
===

I am trying to write a code on excel 2003 to change the background colour of a cell based on the information I have manually entered in a previous cell. This is to show the customer satisfaction scores of our top 10 customers.

I have written this code below but I only know how to make it work for one cell and not for a range of cells. I am an amateur when it comes to using this so any help would be appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)

If Range("B1").Value < Range("A1").Value Then Range("B1").Interior.ColorIndex = 3
If Range("B1").Value = Range("A1").Value Then Range("B1").Interior.ColorIndex = 6
If Range("B1").Value > Range("A1").Value Then Range("B1").Interior.ColorIndex = 45
If Range("B1").Value = 1 Then Range("B1").Interior.ColorIndex = 4
End Sub

This code works perfectly for the one cell but I need to do this for a range of cells in different areas of the spreadsheet

I would like the code to work for cell F26 down to F35 to change colour on the basis of the information that is in column C26 down to C35. As this is over 12 months I would like the code to change the colours of the cells I26 down to I35 from the information in F26 down to F35 and so on. 

Apologies if this sounds like an extremely stupid question but I am an amateur and just looking for some help from someone who is clued up on this 