Excel Cell colour changes

Okay I know I can use conditional formatting on a cell depending on the value within that cell however I want to change its colour depending on the value of an adjacent cell and seeing as Excel is not my forte I wondered if anyone there would know?

Wes

Instead of applying the formatting based on the cell's own value, base on the formula of your choice.

or you can write a visual basic formula i did used to know how to do it but it has been a while will look in the old books if you like

There is probably an easier way but, if I can't see an obvious function, I tend to use a bit of VBA.

The following subroutine checks if A2 is greater than 1. If it is then it changes the colour of A1 to red

Sub change_colour
If cells(1,2).value>1 then
Range("A1").Select
Selection.Interior.ColorIndex=3
End If
End Sub

Attach it to a macro button or key press. If you have a lot of data a for/next loop can easily be added.