|Triplicated...now that's a cool word!|
Let's say your data is in A1:A whatever.
Select the entire range and use this Conditional Formatting Rule:
Notice where I used the $ and where I didn't. You need to let the last row in the range update itself for each cell, which CF will do for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.