Model & Serial Numbers

[ExcelMS]

I have a workbook in which I would like to enter important model and serial
numbers on Sheet 2. If I enter any of the model and serial numbers from
Sheet 2 on Sheet 1, I want the Font of those model and serial numbers on
Sheet 1 to become red and bold. However if I do not enter model and serial
numbers from Sheet 2 onto Sheet 1, then I want nothing to happen to those
model and serial numbers. Any feedback, about how I might pull this off, I
would greatly appreciate. Thank you.

 

[Peo Sjoblom]

First on sheet1 select the range of serial numbers like A2:A500, then type a
name in the name box like MySerials (name box is the little box above A1 and
when you have selected the range you just click the mouse there and type a
name)

Then you go to Sheet2, select the range where you will be typing the serials
(Assume it is A2:A500 as well), with A2 as the active cell (but the whole
range selected) do format>conditional formatting, select formula is and use

=COUNTIF(MySerials,A2)>0


click the format button and select fonts, then bold and rec colour and
finally click OK twice


--


Regards,


Peo Sjoblom

 

[ExcelMS]

God bless you, it works great. Thank you so very much.