View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jack Jack is offline
external usenet poster
 
Posts: 2
Default Conditional formatting based on an equal value in another workshee

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