Not sure what I'm missing here.
On Sheet 1 - R3:47 I have a list of names.
What I want is if a name in that list is on Sheet 1, Sheet 2, Sheet 3 or Sheet 4 then conditional formatting to make that name Green.
I've got it working on one sheet for 1 name but I can't get it working across multiple sheets..
Bookmarks