Conditional formatting based on an equal value in another workshee

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 19 May 2008 06:30 GMT

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.

Signature

Jack

Reply to this Message

Bob Phillips - 19 May 2008 08:50 GMT

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))

Signature

---
HTH

Bob

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

>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.

Reply to this Message