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


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