Conditional Formatting

[Mal]

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

 

[Pete_UK]

If you already have conditional formatting set up for row 1, then
before you enter any data into row 2 you can highlight the cells in the
previous row, click the Format Painter icon then click and highlight
the same cells in the next row (i.e. where you want to put the new
data). You could then remove the CF which applied to the cells in the
previous row. Then start entering your data.

This is a procedural method - would you prefer a formula?

Pete

 

[Mal]

If you already have conditional formatting set up for row 1, then
before you enter any data into row 2 you can highlight the cells in the
previous row, click the Format Painter icon then click and highlight
the same cells in the next row (i.e. where you want to put the new
data). You could then remove the CF which applied to the cells in the
previous row. Then start entering your data.

This is a procedural method - would you prefer a formula?

Pete

 

[Mal]

Pete,
Thanks for your reply. Yes I would prefer a formula. I am trying to
automate the process.
Can you assist?
Thanks,
Mal