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.