In my workbook I have 2 sheets. The first is my data entry, the second is my database.
In this database there are about 70 different names, and each name can have multiple entries. For example: Row 1 - 7 are mister Gates, 8 - 9 are mister Frankenstein, 10 - 14 are mister Dexter and so on.
To group the names/ sort them. I have used two colors in my existing database, blue and light blue, and so I change the filling of the cells. So all the entries of mister Gates are blue, Frankenstein is light blue, and Dexter is blue again. This way I can easily see which names are grouped, and my database doesnt look like a rainbow.
So far so good, this i can do just by filling the cells by hand.
But, when I add a name using my data entry I want two things to happen:
1) First, check if the name exists in the database, give it the colour of that name.
2) When its a new name, give it the next colour, so when the last color is blue, than the next color must be light blue.
Is this possible?
In this database there are about 70 different names, and each name can have multiple entries. For example: Row 1 - 7 are mister Gates, 8 - 9 are mister Frankenstein, 10 - 14 are mister Dexter and so on.
To group the names/ sort them. I have used two colors in my existing database, blue and light blue, and so I change the filling of the cells. So all the entries of mister Gates are blue, Frankenstein is light blue, and Dexter is blue again. This way I can easily see which names are grouped, and my database doesnt look like a rainbow.
So far so good, this i can do just by filling the cells by hand.
But, when I add a name using my data entry I want two things to happen:
1) First, check if the name exists in the database, give it the colour of that name.
2) When its a new name, give it the next colour, so when the last color is blue, than the next color must be light blue.
Is this possible?