Conditional formatting and cell copying

[icissel1234]

I know people have posted similar questions but a search of the threads did not get me anywhere with this:

I select cell a2 of a sheet and conditionally format it with a formula:

=OR(ISBLANK('Coded Prehospital Data'!$A$2),ISNA('Coded Prehospital Data'!$A$2))

when i try to copy this formatting down part of the column (click and drag bottom right corner of a2) the formula is static, so cell a12 still refers to 'Coded Prehospital Data'!$A$2 instead of 'Coded Prehospital Data'!$A$12

I am definately not on the varsity excel team but I thought conditional formatting was dynamic when it comes to cell copying, is the issue that the reference is in a different sheet?

 

[kvsrinivasamurthy]

Replace
Data'!$A$2
By
Data'!$A2
Or
Data'!A2

 

[icissel1234]

Excellent! Thank you

 

[icissel1234]

I spoke too soon.... this worked when i applied the rule on the sheet to which the formula referred