Highlight same part numbers with high price varies among themselv

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Select the range A2:A8
Goto the menu Format>Conditional 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
 
Hi,

Thanks for responding to my question.

I tried and the formula doesn't work. Nothing happens.
 
Tell me exactly what you did, how you did it and where you did it. Post the
*exact* formula you tried. This does work!
 
Back
Top