Quote:
Originally Posted by 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.
|
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