"Samad" wrote:
If employee number 5263 found in sheet 2,
show the raw in main data on sheet 1 in red, for instance.

In Sheet2,
assume the employee numbers would be listed within B1:B200 (say)

In Sheet1,
assume the employee numbers are listed in A1 down
Select col A (A1 active)
Click Format Conditional Formatting, then apply in Condition 1:
Formula is:
=SUMPRODUCT((ISNUMBER(SEARCH(A1,INDIRECT("Sheet2!$ B$1:$B$200")))*(A1<"")))
Format it as, eg: Red fill & white font, bolded

The above will achieve what you're after, ie highlight all employee numbers
in col A which are found within Sheet2's B1:B200. Adapt the range to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---