LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default Depending on Account cell is gray or white question.

I have account names and they are all in alphabetical order ascending. I want
to gray a row of cells on every other account name change.

Example of what I want:
A Row Color
Account 1 Gray
Account 1 Gray
Account 1 Gray
Account 2 White
Account 2 White
Account 2 White
Account 3 Gray
Account 3 Gray
Account 3 Gray

I know I can control-click on every other one but we all know with large
spreadsheets that can take forever. Is there a formula or something else that
can do this automatically/quickly?

I should mention, and I don't know if this will make a difference, but each
account may have different data in the same row as the account name.

For example:
A B Row Color
Account 1 Information 1 Gray
Account 1 Information 2 Gray
Account 1 Information 3 Gray
Account 2 Information 4 White
Account 2 Information 5 White
Account 2 Information 6 White
Account 3 Information 7 Gray
Account 3 Information 8 Gray
Account 3 Information 9 Gray

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL workbook is off-white, goes white in edit mode Joe Excel Discussion (Misc queries) 0 July 15th 06 12:45 PM
how do I apply 10% gray shade to a cell in Excel? myraddin Excel Worksheet Functions 3 May 14th 06 06:48 AM
Gray cell lines Aurora Excel Discussion (Misc queries) 6 April 7th 06 07:23 AM
White Space in a Cell Gina O'Brien New Users to Excel 2 June 17th 05 03:02 PM
Help with function to sum values in a worksheet depending on account number Dab Excel Worksheet Functions 4 June 7th 05 10:08 PM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"