| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional formatting based on an equal value in another workshee
Create a defined name (InsertNameDefine...) 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) "Jack" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| rename worksheet based on contents of a cell in different workshee | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting Based on If and Or | Excel Discussion (Misc queries) | |||
Linear Mode
