It is.

Select all the cells in a row (say A2:H2, total in H2), and all rows
Menu Format Conditional formatting
Change Condition 1 to Formula Is
Add a formula = $H2=0
Click Format
Select pattern and pick a colour
OK
Click Add condition
Change Condition 1 to Formula Is
Add a formula = $H2<0
Click Format
Select pattern and pick a colour
OK
OK

--
HTH

Bob Phillips

"Julian Campbell" wrote in message
...
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