How do I get excel to shade grey at every different vendor name?
 

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

How do I get excel to shade grey at every different vendor name?
 

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

How do I get excel to shade grey at every different vendor name?
 

Eddie

Your subject line states "every different vendor name" but in the body you state
"every other new vendor".

Which do you want?


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 08:35:23 -0500, punter
wrote:


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

How do I get excel to shade grey at every different vendor name?
 

Sorry it took me so long to get back to you. I didn't have a chance to
check the formula but it works great. Thank you so much.


--
punter


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