Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "grey out" a row in excel | Excel Discussion (Misc queries) | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) |