Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cell
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cell
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 "Jupe" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find formatting in text in cell, insert tags around formatting. | Excel Programming | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |