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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com