Conditional Formatting, VBA

Originally Posted by KerahJoy

...set conditional formatting...I don't want to use conditional formatting

This seems contradictory. It's not clear what you want the code to do.

1. Use VBA to create Conditional Formatting rules
2. Use VBA to directly format the cells

Please be more specific about your data and the desired formatting. "set formatting conditions to cells in column D" Which cells? What formatting?

I can show you a solution that does not use conditional formatting, but using built-in features is better than writing code to do the same thing.

How are new columns added? You have no code in this file even though it is a .xslm file, so I don't know if you do this manually, by import, or by code that is not included.

My suggestion is going to be to set up the conditional formatting in D has you have done, then when new columns are added, use VBA to copy & paste formats. That will be much easier and more reliable than writing all of the conditional formatting logic in VBA.

Also you do have a handful of conditional formatting rules that affect a couple of rows, but in looking at your sample I suspect you want other formatting too. Can you give a complete set of requirements for your desired formatting?