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

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

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

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

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

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

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

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

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

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




"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