conditional formating

[remetiffy]

Hi

My problem is I would like to change the colour of a cell by comparing the values in two other cells.

A B C D
Results Target Target Points Results Points
B C 58 52
B B 46 46
D B 4 34
A C 40 52
B B 46 46


I,ve tried all sorts of ways to change the colour of the cells in column A

What I an doing is Selecting A2
Selecting conditional formating
New Rule
use formula to select which cells to format
=(D2>=C2)
format to a green colour
This works ok but when I copy the formula down all the values change to the value of A2 so they all change to B and are coloured green.

I have also tried =($D$2>=$C$2)

I would upload the file but it is about 5mb

Thanks for any help.

[bebo021999]

Copy A2
Paste special/format to other destination cells, not paste only.