If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance.
If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance.
If you do not want to resort to VBA, you will need to use an area on Sheet 1 to make a copy of the column on Sheet 2 that contains the Employee No. This can be done quite simply by making a column e.g. Column Z on Sheet 1 where you enter an equation such as:
=Sheet2!A1 (assuming Cell A1 is where your first employee No appears on Sheet 2)
and copy this down the Sheet 1 rows as far as you need to get all the entries on Sheet 2 (plus more rows for any envisaged expansion)
Then you would use a Conditional Formatting equation like:
==IF(ISNA(MATCH($A2,$G$2:$G$48,0)),FALSE,TRUE) (assumes copied Employee Nos are in the cell range Z1 to Z48)
Last edited by PeterB; 02-07-2007 at 08:52 AM.
You can do this by creating a named range in one worksheet, i.e. use
Insert > Name > define to create a named range where you expect to find the employee number, e.g. datalist
then in the worksheet with your main data, for row 2 with employee number in A2, select whole row and use conditional formatting with formula is option
=COUNTIF(datalist,A$2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks