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?