I have a workbook with multiple sheets that contain names, email addresses, etc. I need to highlight a cell in one worksheet based on whether or not the same data exists in another worksheet. Per my example if a name in Sheet 1 Column B also exists in Test Column B, I want the cell to be highlighted. The data will not be in the same order and information is continually added to both sheets. The data in Test will be manually entered while the data in Sheet 1 will be imported from an other program.
Any assistance would be greatly appreciated.