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