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