I have a row of 70 colours (EACH COLOUR occupies several cells)
Now, what I want to do is –
For each colour in the range , I want to clear contents except for the first cell of each colour.
Like this row – I have 5 rows to perform. Please let me know if Im not clear or if you ave some questions