Conditional Formatting (CF) will do what you want, but you need to duplicate
the data on your second sheet into your first sheet because CF can't use a
condition that reference another sheet. So, in some unused column of Sheet1
(for my example below, I'll assume that column is X), put this formula in
its third row....

X3: =Sheet2!A3

and then copy it down to row 700. Now, highlight the entire column and Hide
it (no need to look at the duplicated information on your original sheet).
Next, on Sheet1, click in A3 and drag down to A700 to select the range
A3:A700 keeping A3 the active cell (the active cell is the one that is not
shaded within the selection). Then, click on...

Format/Conditional Formatting...

in Excel's menu bar. Select "Formula Is" in the first drop-down and
Copy/Paste the following formula into the blank field next to the drop
down....

=NOT(ISERROR(MATCH(A1,$X$1:$X$700,0)))

Click on Format button and pick the color you want for the cell from the
Patterns tab on the dialog box that appears. OK your way back to the
spreadsheet. The locations you fill in on Sheet2 should now highlight in the
selected color on Sheet1.

Rick


"Sean" wrote in message
...
I have a workbook with two (2) sheets on it. On sheet one (1) I have all
my
warehouse locations on it down column "A" from rows 3 to 700. On sheet
two
(2) in column "A" I enter daily the locations that have been verified! I
want sheet one (1) to highlight in yellow the locations that have been
verified and leave the other ones alone, so I know what needs to be done
still? Any help on this would be grateful...

Thanks,

Sean