Conditional formatting issue

[Boorisher]

Hi

I am hoping you can help

I have a conditional formatting issue that has just started to operate different and need some answers
Example - I used cell formatting to make red and bold if one cell does not equal another cell

If cell A1 does not equal D1 then red bold text

I then want to copy it down the worksheet so that

If cell A2 does not equal D2 then red bold text
If cell A3 does not equal D3 then red bold text

but the next value A2 still refers to D1

I have tried removing the $ symbol before the 1 but it appears back and, I cannot get it to work

Cheers

 

[PeteWright]

Does this work:
Formula:

=$A1<>$D1

Applies to:

=$A:$A

Book0002.xlsm
	A	B	C	D
1	blah			bla
2	blub			blubb
3	abc			abcdef
4	xyz			xyz1
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Expression	=$A1<>$D1	text	NO

 

[Boorisher]

Does this work:
Formula:

=$A1<>$D1

Applies to:

=$A:$A

Book0002.xlsm
	A	B	C	D
1	blah			bla
2	blub			blubb
3	abc			abcdef
4	xyz			xyz1
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Expression	=$A1<>$D1	text	NO

Hi Pete
That's brilliant thank you , entered it as a formula and it works
And thanks for the quick reply
Cheers