Copying Conditional Formatting Rule

Hi there
I have a simple list produced in excel 2007, attached, where I wish to change the colour of the text when an entry is made in column H.
I can get it to work once but can't copy the formatting rule. In the "applies to" part of the rule it will only accept absolute values.
Any ideas how I can get this to copy as it will end up a very long list and isn't practical for me to set up an individual rule for each row.
Cheers.