"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?