Conditional Formatting delete rules and create new with a formula as a macro

[smak]

I want to create a macro that does the following steps

1. delete all rules in columns
   1. Column D:G and columns N:O
   2. total of 6 rules
   3. these will be the only rules on this workbook
2. Create new rule
   1. Formula/Rule : =AND($D1<>$P1,$B2="No")
   2. olor to GBH 237,125,49
      1. the orangish color on the top row of the colors on the theme colors screen
         1. the 5th one in the row

how

 

[Joe4]

If you turn on your Macro Recorder, and record yourself performing these steps manually, it should give you the VBA code you require.
The Macro Recorder is a great tool for getting snippets of code like this.
You can often "clean it up" a little afterwards, if you like (i.e. getting rid of unnecessary "Select" statements), though it is not necessary.