Formatting cell

[Jupe]

I am making a to do list. Once the item is done I have a column next to it
that I put an "x" in to show that it is complete. I would like the item or
cell to change colour, or fade, or have a line put through it; something to
differentiate it quickly that it is done.
(using Excel 2007)

 

[Tom Hutchins]

You want to use conditional formatting. I don't have XL2007 at hand, but here
is the general idea. I'll assume you are entering the to-do list in column B
and putting the X in column A.

Select column B. Open the conditional formatting dialog. You need to select
'Formula Is' instead of 'Cell Value Is'. Enter this formula in the text box:
=(OFFSET(B1,0,-1)="X")
Change B1 as needed to the column you are actually using. The -1 argument
tells OFFSET to look one column to the left of the column (B) in the first
argument. A positive value tells it how many columns to the right to look
instead. Edit this argument as needed.

Click the Format button and select the formatting you want to appear when
the condition is true.

Hope this helps,

Hutch