Automatic color fill
 

I have a spreadsheet with over 1400 line entries. I am marking them with an
'x' in the 'complete' column when I have completed that line but it's getting
to be harder to read because of the amount of data. I was wondering if there
is any way to make the box and/or line change to a certain color (i.e. green
or blue) when I mark my 'complete' column with an 'x'. Please help.

Automatic color fill
 

Let's say the 'x' entries are in column J
Select J1:J1400 (or all of column J by clicking the column header)
Use Format | Conditional Formatting; in the dialog use
Cell Value Is Equal To "X"; then click the Format button on the dialog and
change the pattern fill or font colour as required
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SLKoelker" wrote in message
...
I have a spreadsheet with over 1400 line entries. I am marking them with an
'x' in the 'complete' column when I have completed that line but it's
getting
to be harder to read because of the amount of data. I was wondering if
there
is any way to make the box and/or line change to a certain color (i.e.
green
or blue) when I mark my 'complete' column with an 'x'. Please help.

Automatic color fill
 

Thanks so much it worked like a charm!! Now I have one more question, hope
you can help.

Is there a way to also make another column shade if it has an 'x' in it? Let
me try that again.

I put a 'x' in column J and it turns green (thank you), well that column
directly correlates to column L. Now column L is already filled out with
either an 'x' or 'y'.
When I put an 'x' in Column J is there a way that it will automatically
shade column L if there is an 'x' in that column?? Please help.

"Bernard Liengme" wrote:

Let's say the 'x' entries are in column J
Select J1:J1400 (or all of column J by clicking the column header)
Use Format | Conditional Formatting; in the dialog use
Cell Value Is Equal To "X"; then click the Format button on the dialog and
change the pattern fill or font colour as required
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SLKoelker" wrote in message
...
I have a spreadsheet with over 1400 line entries. I am marking them with an
'x' in the 'complete' column when I have completed that line but it's
getting
to be harder to read because of the amount of data. I was wondering if
there
is any way to make the box and/or line change to a certain color (i.e.
green
or blue) when I mark my 'complete' column with an 'x'. Please help.

Automatic color fill
 

To clarity: you want to shade L cells if they AND the corresponding J cells
contain X ?
Select the L cells and use (I will assume the first select cell is L2)
Formula Is: =AND(L2="X", J2="X")
Click Format button on dialog and set you fill colour
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SLKoelker" wrote in message
...
Thanks so much it worked like a charm!! Now I have one more question, hope
you can help.

Is there a way to also make another column shade if it has an 'x' in it?
Let
me try that again.

I put a 'x' in column J and it turns green (thank you), well that column
directly correlates to column L. Now column L is already filled out with
either an 'x' or 'y'.
When I put an 'x' in Column J is there a way that it will automatically
shade column L if there is an 'x' in that column?? Please help.

"Bernard Liengme" wrote:

Let's say the 'x' entries are in column J
Select J1:J1400 (or all of column J by clicking the column header)
Use Format | Conditional Formatting; in the dialog use
Cell Value Is Equal To "X"; then click the Format button on the dialog
and
change the pattern fill or font colour as required
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SLKoelker" wrote in message
...
I have a spreadsheet with over 1400 line entries. I am marking them with
an
'x' in the 'complete' column when I have completed that line but it's
getting
to be harder to read because of the amount of data. I was wondering if
there
is any way to make the box and/or line change to a certain color (i.e.
green
or blue) when I mark my 'complete' column with an 'x'. Please help.