Conditional Formatting help in Excel

I want to copy conditional formatting from one cell to another within the same column and have it work without having to manually change the conditional formatting rule. Can you help?