Conditional Format a Row (Macro)

Hi Guys,

i need to format cell colours of a row based on contents of certain cells, conditional formatting is no good as there are too many arguments I beleive.

Please see attached which will explain my requirements.

Many thanks

James