Conditional Formatting Formula - Macro

[grey]

I'm trying to create a macro

Please Login or Register  to view this content.

I know this is probably really simple, but I'm getting stuck on how to make that H2 so that it's a dynamic reference to the cell in question..

So if this conditional formatting was applied to H2, it would be correct, if it was applied to H3, that should say H3 and so on.

Can anyone tell me where I'm going wrong?

Thanks!

[StephenR]

Have you tried changing the H2 to A2?