Chers Sloth for your help, much appreciated.

"Sloth" wrote:

What you want is conditional formating.

Select the area you want the condiotional formatting to apply to.

Select format-conditional formatting

Select formula is

Insert:

=$A10

as your formula (yes use both = and charecters).

select the formatting you want and select ok.

this will highlight an entire row if the cell in colum A highlighted. You
mentioned you want it to be the last one in the row, but did not mention
which column is your last. If you wanted column G then insert:

=$G10

"fomula problems" wrote:

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