Copy Conditional Formatting only

[Eskercat]

Morning,
I have a sheet with conditional formatting set to show duplicates within a column range. Each column should have no duplicates, but duplicates across rows is expected. I am also using colours to denote different groupings within the data (belonging to different departments).
My conditional formatting is working fine, however, I am looking for a quick way of copying this between ranges (down different columns), without disrupting the formatting within the rest of the cells (e.g. the background colour or the font colour). I can't use the format copier, or paste special as this is going to change these. I am aware I can put the conditional format into one of the cells and change the range each time, but that will mean completing that approximately 300 times. Any ideas?
Thank you!

 

[Joe4]

Welcome to the Board!

Your best bet may be to true to use VBA, where you can select the range you want to apply the Conditional Formatting rule to, and have VBA create it.

If you do not know how to do that, we can help you, if you provide more details, such as:
1. What is the exact Conditional Formatting rule?
2. How do you want the user to communicate which range to apply it to (it could be applied to whatever range they have selected prior to running, or we could have a prompt asking them to enter the range to apply it to)?

 

[Eskercat]

Thank you for the welcome, and the response. I did think that might be the answer. I will crack on with it. Much appreciated.

 

[Joe4]

You are welcome.

Feel free to post back if you run into any issues trying to implement the solution.