Conditional Format on a Row (Table)

Morning

Greetings from Scotland

I have a measure which is True for a when a Task status being in the status Complete

I use the measure as a conditional format in a table to turn it (the row/cell elements) green as the task is complete, I basically want to show all fields as green See Fig 1

The last entry – the task is not complete and so its stays as it is.

My issue is that I had to set this measure on each cell element individually.

If I had 20x columns; that’s 20x columns  where I had to cerate the conditional format

Is there no way to say for a row that if the value is complete, then all cell elements are complete?

i.e the who;e row turns green? 

If you look at Fig 2 – just for discussion; for each column (5x columns) I had  to go in and set the Conditional Format 5X Times.

If I have 20x columns – that is a pain.

Am I making sense?

Fig 1

Fig 2 Excel Mock-up

Comments welcome

Jimmy