Thread: Rows ColorIndex
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CG Rosén CG Rosén is offline
external usenet poster
 
Posts: 74
Default Rows ColorIndex

Hi Group,

Needs some help on following;
Have a column with variable values as:
1
1
1
2
2
3
4
4
4
5
5
etc
The number of rows with 1:s etc are changing. Try to give the rows with the
same value the same InteriorColor in 2 shades.
First all 1:s to be ColorIndex =15 then the 2:s Colorindex = 0 then again
the 3:s ColorIndex = 15 etc.
What is the best approch to this ?

Happy New Year

CG Rosén