row shading when a value of 0 is entered at the end of the row

F

fomula problems

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
 
F

fomula problems

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
 
S

Sloth

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:

=$A1>0

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:

=$G1>0
 
F

fomula problems

Chers Sloth for your help, much appreciated.

Sloth said:
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:

=$A1>0

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:

=$G1>0
Click to expand...
 
F

fomula problems

Not sure if this is what i want, my worksheet is something like this:
A B C D E G
1 63 59 78 89 58 12:40
2 22 54 36 74 25 11:10
3 19 36 27 46 58 12:25
4 46 98 68 96 56 0

When i enter a time is column G i would like the wholeof that row to
highlighted up to and including G, if i enter 0 because a time has not been
established i do not want the row to be highlighted, but then if i do
establish a time late i can enter the time and the row will be highlighted,if
the formula you gave me will do that, could you also let me know how to enter
it on the worksheet, new to this sortof thing.
Alan
 
Top