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

P

punter

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
 
B

Bernie Deitrick

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
 
G

Gord Dibben

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
 
P

punter

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.
 
Top