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% ??