Conditional Formatting using multiple sheets
 

I am trying to setup a wookbook for tracking daily in/out for employees. I
have a sheet listing all employees. I have a second sheet that lists the
same names and has a column for "Unavailable". I would like to setup the
workbook such that when an X is next to the name in the second sheet, all
instances of that name in the first sheet are striked out.

Is it possible to setup conditional formatting to accomplish this?

Conditional Formatting using multiple sheets
 

Name the data on Sheet2 as (for example) 'Names' and 'Unavailable'

On Sheet1 set CF:

FormulaIs:
=INDEX(Unavailable,MATCH($A1,Names,0))="X"

Select Format and check "Strikethrough"

OK.

HTH


"kwinston" wrote:

I am trying to setup a wookbook for tracking daily in/out for employees. I
have a sheet listing all employees. I have a second sheet that lists the
same names and has a column for "Unavailable". I would like to setup the
workbook such that when an X is next to the name in the second sheet, all
instances of that name in the first sheet are striked out.

Is it possible to setup conditional formatting to accomplish this?

Conditional Formatting using multiple sheets
 

I've defined names for both data ranges. However, the formula below is not
formatting. The two data ranges are two different sheets...how can that be
accomplished?

Thanks!

"Toppers" wrote:

Name the data on Sheet2 as (for example) 'Names' and 'Unavailable'

On Sheet1 set CF:

FormulaIs:
=INDEX(Unavailable,MATCH($A1,Names,0))="X"

Select Format and check "Strikethrough"

OK.

HTH


"kwinston" wrote:

I am trying to setup a wookbook for tracking daily in/out for employees. I
have a sheet listing all employees. I have a second sheet that lists the
same names and has a column for "Unavailable". I would like to setup the
workbook such that when an X is next to the name in the second sheet, all
instances of that name in the first sheet are striked out.

Is it possible to setup conditional formatting to accomplish this?

Conditional Formatting using multiple sheets
 

"I have a second sheet that lists the same names and has a column for
"Unavailable". "

According to your posting, the second sheet contains both names and
unavailable: these are the named ranges. How else are you going to link names
to the "unavailable" flag?

"kwinston" wrote:

I've defined names for both data ranges. However, the formula below is not
formatting. The two data ranges are two different sheets...how can that be
accomplished?

Thanks!

"Toppers" wrote:

Name the data on Sheet2 as (for example) 'Names' and 'Unavailable'

On Sheet1 set CF:

FormulaIs:
=INDEX(Unavailable,MATCH($A1,Names,0))="X"

Select Format and check "Strikethrough"

OK.

HTH


"kwinston" wrote:

I am trying to setup a wookbook for tracking daily in/out for employees. I
have a sheet listing all employees. I have a second sheet that lists the
same names and has a column for "Unavailable". I would like to setup the
workbook such that when an X is next to the name in the second sheet, all
instances of that name in the first sheet are striked out.

Is it possible to setup conditional formatting to accomplish this?