In my list I have a "name" and information linked to that name, so I write "1" as a first case in the A column and then fill the rows next with the information and color all the rows that belong to the information of each case to highlight them. I want to create a conditional format that let me highlight with a different color every new case I enter with their "linked information" rows but only until I enter the next number. e.g. 1, 2, 3, 4...10.
Thank you very much and sorry If my explanation is not very clear.
Yes I had an idea that it would take me to create rules for every single number but I didn't know where or how to start the formula. I am reading and going through on how to create formulas in excel. Your solution works great and I really appreciate you taking some time and effort to help me out.