Conditional Formating??
 

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:


--
mizunobill
------------------------------------------------------------------------
mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614
View this thread: http://www.excelforum.com/showthread...hreadid=533936

Conditional Formating??
 

I have posted an example using conditional formatting to
http://cjoint.com/?esxz752EI1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mizunobill" wrote
in message ...

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:


--
mizunobill
------------------------------------------------------------------------
mizunobill's Profile:
http://www.excelforum.com/member.php...o&userid=33614
View this thread: http://www.excelforum.com/showthread...hreadid=533936

Conditional Formating??
 

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.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=533936

Conditional Formating??
 

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.


--
mizunobill
------------------------------------------------------------------------
mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614
View this thread: http://www.excelforum.com/showthread...hreadid=533936

Conditional Formating??
 

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=533936