Conditional format based on another cell on another page

Closed
terrist
Posts
1
Registration date
Tuesday June 3, 2014
Status
Member
Last seen
June 3, 2014
- Jun 3, 2014 at 03:55 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jun 4, 2014 at 07:38 AM
I have two databases. One is a list of parents and the other a list of students. The parents each have a unique 'Parent ID.' I need to evaluate each student last name on one page and see if it matches a parent last name on the other page. If it does, I need the student to get the same, unique 'Parent ID.'

Any ideas? Thanks!

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jun 4, 2014 at 07:38 AM
CAN YOU PLEASE POST A EXTRACT OF TWO SHEETS FIVE ROWS EACH
0