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

  • Thread starter Thread starter punter
  • Start date Start date
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
 
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
 
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
 
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.
 
Back
Top