Hello all

I would like to be able to use conditional formatting so that when I enter a value in a cell it highlights the first 4 cells in that row.

There is already a formula in place that means all cells from E5:LZ203 highlight green if a value is entered (=NOT(ISBLANK(E5)).

Eg: I have entered “2” into cells V6:W6 and they go green.

However in addition what I would like to happen is that the first 4 cells in that row change colour (basically means it’s planned). In this case A6:D6.

Help!