I wonder if someone could help me please with embedding the following commands made via the Excel dialogue box into a macro which I am using for technical vetting of orders and shipments. The scenarios are both different and need to be included in the same macro.

Scenario 1

Select all none empty cells in column C and conditionally format as follows :-

All cells with the letter “P” in it – Colour fill red
All cells with the letter “O” in it – Colour fill amber
All cells with the letter “F” in it – Colour fill green

Scenario 2

Select all none empty cells in column G and conditionally format as follows :-

Formula =AND(L2>0,M2<(TODAY()+5)) – Colour fill red
Formula =AND(L2>0,M2<(TODAY()+7)) – Colour fill amber

Lastly, how do I write in a command to change the zoom to 75% ??