Conditional formatting based on an equal value in another workshee

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

I have a large spreadsheet with part numbers and prices. Have a second
worksheet with part numbers and special prices. I want to have the first
sheet cell to format bold/colur if the part number appears in the special
list in the second sheet which is dynamic. Parts are being added or removed
over time. Both partnumbers are in column B.
 
Create a defined name (Insert>Name>Define...) for the list in the other
sheet, then use a formula of

=ISNUMBER(MATCH(A2,the_list,0))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top