Conditional Formating??

M

mizunobill

I have tried to do this several different way and can not find and easy
way to do it.
Item # MFG Desc.
150940 BS 295/75R22.5/14 M725 Highlighted
150940 BS 295/75R22.5/14 M725 Highlighted
150940 BS 295/75R22.5/14 M725 Highlighted
150991 BS 285/75R24.5/14 M725 Not Highlighted
150991 BS 285/75R24.5/14 M725 Not Highlighted
151300 BS 315/80R22.5/20 M843 EC DRV Highlighted
151300 BS 315/80R22.5/20 M843 EC DRV Highlighted
151300 BS 315/80R22.5/20 M843 EC DRV Highlighted
152498 BS 265/70R19.5 M729 14P Not Highlighted
152935 BS 11R22.5/14 M725 AZ TL ST Highlighted

Any time the item # changes then it alternates between shaded and not
shaded, any ideas?

Thanks for the help:confused:
 
T

tony h

I think you need an additional column on which to base the flag if the
new column is B set the first value to true then a formula of
=IF(A2=A3,B2,NOT(B2)) use this result to drive the conditional
formatting

hope this helps. I suspect there is a cleaner way.
 
M

mizunobill

I don't think I explained what I am trying to do. Your formula just
indicates the first row when a part number changes. I want to have all
of the same part numbers one color and then when the number changes
then it switches color.

I tried to indicate this, if you look at the far right column it say
highlighted or not highlighted this would indicate colored or not
colored. I have sent an attachment of what it should look like.
 
T

tony h

It should block the groups of same values with a true or false value
The TRUE in the example is in cell B2

1 TRUE result true
1 =IF(A2=A3,B2,NOT(B2)) result true
2 =IF(A3=A4,B3,NOT(B3)) result false
2 =IF(A4=A5,B4,NOT(B4)) result false
3 =IF(A5=A6,B5,NOT(B5)) result true
3 =IF(A6=A7,B6,NOT(B6)) result true
4 =IF(A7=A8,B7,NOT(B7)) result false

regards
 
Top