Sorry to confuse you all but that question should have been that i want the
row to shade when a value greaterthan 0 is entered at the end of each rowso
if say 3 is entered at the end of a row the roew will be shaded if it reverts
back to 0 the shading come off.
Alan

"fomula problems" wrote:

I have a spread sheet that i would like to have row shading when o is entered
in a cellbut will revert back to unshaded when this figure is incresaed above
0, any suggestions.
Alan