I am trying to colour format a row of four cells contained in four columns.

The numbers in the rows change as values are input progressively to rows in
other cells of the spreadsheet but remain constant once past the current
row. In the example below, when a value is entered in cell a2, the values in
e2,f2,g2,&h2 will change and the values in e1,e2,e3,& e4 will become
constant.

What I am trying to do using the example below is to have cells less than 4
formatted as green, greater than 4 as red and equal to 4 no colour
formatting.

So before I enter data in cell a2, e1 will be green, f1 none, g1 red and h1
green. So far I can do this using Conditional Formatting.

What I now want to do before I enter data in cell a3, is clear the colours
in cells e1,f1,g1& h1 and apply it to cells e2,f2,g2 & h2. So e1 to h1 will
still have values 2,4,11 & 3 but with no formatting and e2 will be red, f2
green, g2 green & h2 none. At any one time only one row of four cells will
be highlighted.

Any help appreciated.

e.g.
e f g h
1 2 4 11 3
2 10 2 1 4
3 1 4 2 3

Thanks,
Mal