| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight same part numbers with high price varies among themselv
I have the same parts but part pricing vary. It's ok if the price varies but
more than or equal to $20.00. I want to highlight the same part and part price to highlight by itself. Example 11111 I dont want highligts because the pricing is similar. But 8888 i want highlights because more than $20.00 Part Number Part Price 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight same part numbers with high price varies among themselv
Try this:
Assume this data is in the range A2:B8 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 Select the range A2:A8 Goto the menu FormatConditional Formatting Select: Formula Is Enter this formula** in the box on the right: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF(A$2:A$8=A2,B$2:B$8))=20 Click the Format button Select the style(s) desired OK out ** If your price range might include empty cells use this version of the formula: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF((A$2:A$8=A2)*(B$2:B$8<""),B$2:B$8))=20 -- Biff Microsoft Excel MVP "CYNTHIA" wrote in message ... I have the same parts but part pricing vary. It's ok if the price varies but more than or equal to $20.00. I want to highlight the same part and part price to highlight by itself. Example 11111 I dont want highligts because the pricing is similar. But 8888 i want highlights because more than $20.00 Part Number Part Price 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight same part numbers with high price varies among them
Hi,
Thanks for responding to my question. I tried and the formula doesn't work. Nothing happens. "T. Valko" wrote: Try this: Assume this data is in the range A2:B8 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 Select the range A2:A8 Goto the menu FormatConditional Formatting Select: Formula Is Enter this formula** in the box on the right: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF(A$2:A$8=A2,B$2:B$8))=20 Click the Format button Select the style(s) desired OK out ** If your price range might include empty cells use this version of the formula: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF((A$2:A$8=A2)*(B$2:B$8<""),B$2:B$8))=20 -- Biff Microsoft Excel MVP "CYNTHIA" wrote in message ... I have the same parts but part pricing vary. It's ok if the price varies but more than or equal to $20.00. I want to highlight the same part and part price to highlight by itself. Example 11111 I dont want highligts because the pricing is similar. But 8888 i want highlights because more than $20.00 Part Number Part Price 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight same part numbers with high price varies among them
Tell me exactly what you did, how you did it and where you did it. Post the
*exact* formula you tried. This does work! -- Biff Microsoft Excel MVP "CYNTHIA" wrote in message ... Hi, Thanks for responding to my question. I tried and the formula doesn't work. Nothing happens. "T. Valko" wrote: Try this: Assume this data is in the range A2:B8 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 Select the range A2:A8 Goto the menu FormatConditional Formatting Select: Formula Is Enter this formula** in the box on the right: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF(A$2:A$8=A2,B$2:B$8))=20 Click the Format button Select the style(s) desired OK out ** If your price range might include empty cells use this version of the formula: =MAX(IF(A$2:A$8=A2,B$2:B$8))-MIN(IF((A$2:A$8=A2)*(B$2:B$8<""),B$2:B$8))=20 -- Biff Microsoft Excel MVP "CYNTHIA" wrote in message ... I have the same parts but part pricing vary. It's ok if the price varies but more than or equal to $20.00. I want to highlight the same part and part price to highlight by itself. Example 11111 I dont want highligts because the pricing is similar. But 8888 i want highlights because more than $20.00 Part Number Part Price 11111 20.00 11111 20.00 11111 21.00 11111 22.00 88888 20.00 88888 45.00 88888 22.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CF to highlight lowest price in row | Excel Worksheet Functions | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| How do I formulate a high price column | Excel Discussion (Misc queries) | |||
| Recording a high price on a worksheet | Excel Worksheet Functions | |||
| Highlight in Excel When I Use High Contrast Black Windows Color Sc | Excel Discussion (Misc queries) | |||
Linear Mode
