How to loop after loop in excel

To do that I'd set up an array of 11 different colors:

            Color[] colors = new Color[11]
            {
               Color.Black,
               Color.Red,
               Color.Yellow,
               Color.Blue
               // plus 7 others
            };

You can then do:

      while (datardr.Read())
      {
         if (j == k)
         {
              Worksheet.Cells[j + 1, 1] = cmbName.Items[i].ToString();
              Worksheet.Cells[j + 1, 1].Interior.Color = Color.Green;
         }      
         Worksheet.Cells[j + 1, 2] = datardr[0].ToString();
         Worksheet.Cells[j + 1, 3] = datardr[1].ToString();
         Worksheet.Cells[j + 1, 4] = datardr[2].ToString();
         for(int c = 2; c <= 4; c++) WorkSheet.Cells[j + 1, c].Interior.Color = colors[i];
         j = j + 1;
      }

Hi Vulpes,

I wanted to show every person data in different colors.

I tried like this:

Worksheet.Cells[j + 1, 1].Interior.Color = Color.Geen; // I wanted to show name column with

// For the following data I wanted to one unique color to Name

Worksheet.Cells[j + 1, 2].Interior.Color = Color.Yellow;
Worksheet.Cells[j + 1, 3].Interior.Color = Color.Yellow;
Worksheet.Cells[j + 1, 4].Interior.Color = Color.Yellow;

Darma