View Single Post
  #1   Report Post  
reno
 
Posts: n/a
Default conditional formatting or vba?

have a list of 200 accounts indentified with unique account numbers. each of
these accounts may have from one to x entries that would begin with account
number in column 2. these rows are sorted in ascending order

i'd like to use one green row and a default white row such that all of the
same account number entries would bee the same color and the next set of
account number would be the alternate color.
eg:
Line # Acct# Date Result
1 1 .... ....
2 1
3 2
4 3
Lines 1,2 and 4 would be green and line 3 would be white and so forth.

any suggestions