I have a line of information showing product description and initial
quantity purchased.

On the same line I have a daily use mon / fri with an auto sum at the end of
the row showing balance remaining.

When this last cell reaches 0, I would like the whole line to highlighted in
a colour (text or background)

Again, the same as above if the end cell reaches <0

Any Ideas

Thanks

Julian