using conditional formatting on with Excel VBA

[Hajer]

Dear All,

I am a beginner in VBA and I wan to know the simplest way to add conditional formatting for my Macro. please help.

 

[Joe4]

Welcome to the Board!

One simple way is to turn on your Macro Recorder and record yourself applying the conditional formatting.
Then you will have the VBA code you need to do it. You can then edit the code to make it more dynamic, if you need.