Hi,

I have a problem. I would like to update some old ID with new ID and
new names.

I have 3 columns at the moment, Say ColA is the old ID numbers, Col C
is new ID numbers and Col B are names of the new ID numbers

I want to check if the ID numbers in Col A is equal to Col C. If this
is the case, I want to display the relevant names in Col B.
otherwise, display 0.

Can i do a conditional formatting where if A1=C1, display B1? otherwise
zero?

But ColB and ColC are relevant to each other, how can i do that?

Thanks very much.

Dont need Conditional Formatting, just set a cell say in D column

=IF(A1=C1,B1,0)

and copy the formula down the D colum

--
Special-

-----------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...nfo&userid=747
View this thread: http://www.excelforum.com/showthread.php?threadid=56741