Eddie,

Assuming that your data is sorted by Vendor in column B, you could use a column of helper formulas,
such as this formula (entered in cell A2 using Ctrl-Shift-Enter)

=SUM(1/COUNTIF($B$2:B2,$B$2:B2))

Copy the formula down to match your vendor names.

Then select your rows of data and use Conditional Formatting, with the custom formula:

=MOD($A2,2)=1

HTH,
Bernie
MS Excel MVP


"punter" wrote in message
...

Hi,

I have a spreadsheet with many different vendor names. I want to use
the fill color function to shade every other new vendor. Anyone know
how to do this?

Thanks

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=558425