Model & Serial Numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ExcelMS - 24 May 2008 16:22 GMT

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.

Reply to this Message

Peo Sjoblom - 24 May 2008 20:42 GMT

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

Signature

Regards,

Peo Sjoblom

> I have a workbook in which I would like to enter important model and
> serial
[quoted text clipped - 6 lines]
> I
> would greatly appreciate. Thank you.

Reply to this Message

ExcelMS - 24 May 2008 22:15 GMT

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

> 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
[quoted text clipped - 20 lines]
> > I
> > would greatly appreciate. Thank you.

Reply to this Message