J
John
Re: Bold cells on 'Tally Sheet' in columns F thru AD
Intro: Sheet 'Nov-Sat-12' column A and 'Tally Sheet'
column A contain identification numbers for people.
Event: The cells on 'Tally Sheet' in column F do a lookup
on 'Nov-Sat-8' column A for an identification number, and
if one is there, it copies the number on 'Nov-Sat-8'
column N to 'Tally Sheet' column F in the row with the
corresponding identification number.
Need: If, and only if, there is a number on 'Nov-Sat-8'
column T in the same row as the number on 'Nov-Sat-8'
column N, then the number that is copied to 'Tally Sheet'
column F needs to be bold.
FYI: Identification numbers are always in the same row of
column A on the 'Tally Sheet' but can occur in any row of
column A on the 'Nov-Sat-8' sheet.
There are other columns with which I need to do the same.
You may want to see the whole file to get my drift.
Many thanks in advance for your help!
John
Intro: Sheet 'Nov-Sat-12' column A and 'Tally Sheet'
column A contain identification numbers for people.
Event: The cells on 'Tally Sheet' in column F do a lookup
on 'Nov-Sat-8' column A for an identification number, and
if one is there, it copies the number on 'Nov-Sat-8'
column N to 'Tally Sheet' column F in the row with the
corresponding identification number.
Need: If, and only if, there is a number on 'Nov-Sat-8'
column T in the same row as the number on 'Nov-Sat-8'
column N, then the number that is copied to 'Tally Sheet'
column F needs to be bold.
FYI: Identification numbers are always in the same row of
column A on the 'Tally Sheet' but can occur in any row of
column A on the 'Nov-Sat-8' sheet.
There are other columns with which I need to do the same.
You may want to see the whole file to get my drift.
Many thanks in advance for your help!
John