Model & Serial Numbers
 

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.

Since it’s possible to have two or more items with the same Model number you should consider the Serial numbers as the bases for conditional formatting. Assuming your data starts in row 2 columns A (Model #) and B (Serial #). Select your range of data in column B Sheet2 and give it a define name “SerNo”. Move to cell A2 on Sheet1 and apply conditional formatting with this formula.

Condition 1:
Formula Is: =COUNTIF(SerNo,$B2)0

http://www.cpearson.com/excel/cformatting.htm#DefName

Model & Serial Numbers
 

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 formatconditional 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" wrote in message
...

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.

Model & Serial Numbers
 

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

"Peo Sjoblom" wrote:

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 formatconditional 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" wrote in message
...

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.