Conditional Formatting of a cell based on another cell being empty

[RSeymour]

Hello,

I have been struggling with getting Excel 2003 and Excel 2007 to conditionally format the font of a cell if another cell on the same row is empty.

For example, if cells A1 to A5 are filled with a mixture of data types (text, date, numbers, etc) and cell A6 is null then the font for cells A1 to A6 should be Arial. When any value is entered into cell A6 the font for cells A1 to A6 should conditionally format to Arial strikethrough. If the strikethrough font can't be done then shading or colouring will do just as well.

I need to apply this to a large checkoff list.

Thanks

RSeymour

 

[SkipVought]

Hi,

What have you tried so far?

Is something not working for you?

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[RSeymour]

I can get conditional formatting to work on a single selected cell, but not for a range of cells based on a null value in another cell.

What I need is something like:

- If A6 is null then do nothing
- If A6 is not null then the font for A1 to A6 is Arial strikethrough

I've tried all the various wizards and online help but none specify how to format if a cell is empty/not empty

Thanks for the fast response.

 

[SkipVought]

1) Shade/format font for the condition where the cell in question has a value.

2) select the other cells in the column.

3) Format > Conditional Formatting

4) Select Formula is. In the textbox enter
[tt]
=isblank(
[/tt]
click on the cell that will or will not contain a value.
hit F4 until the ROW is absolute
colse the parenthesis.

5) assign the formatting

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[SkipVought]

1) Shade/format font for the condition where the cell in question has a value.

2) select the other cells in the column.

3) Format > Conditional Formatting

4) Select Formula is. In the textbox enter
[tt]
=isblank(
[/tt]
click on the cell that will or will not contain a value.
hit F4 until the ROW is absolute
close the parenthesis.

5) assign the formatting

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[RSeymour]

Thanks! I will try this in the morning!

R