Vba conditional formatting macro partial running

Hi I am trying to create a spreadsheet with many variables, and want them all to conditionally format when they auto-populate various other worksheets. The auto-formatting will vary from sheet to sheet dependant on primary user preferences, but the template will be the same for all. I am having issues with the template though, as I can only get the first 3 commands to run on it? Can anyone out there fix it as I am a total newb on VBA, and have taught myself everything I know on it in the last 2 days...

Any help would be much appreiciated,

Cheers,

oli

Here is the macro:

Please Login or Register  to view this content.