Conditional Formatting - Coloring Cells based on Values

I have a workbook that has numbers in rows and columns but majority of cells are empty. I want to be able to color the cells that are not empty and has a number greater than 5. 5 different But I want to use different colors for different rows, or atleast 5 different colors for 5 different rows and then the colors can repeat themselves. There are about 50 rows and 12 columns that have data.

I know that I can use conditional formatting to format them in one color when it is more than 5 but I dont know how to do different colors.

I have attached a sample worksheet with the before and after tab.

Any help is really appreciated.

Hi Fotis, Thanks a lot for such a quick reply !

In the file that you have attached, the conditional formatting is not working properly, see eg F3 and K3 should not be highlighted, similarly J3 J4 and L4 should be highlighted ! Do I need to change the formula?

BTW. Thanks for the link, I am still reading it, it has lots of information !!

This is awesome. I looked at the formula and was wondering how will the formula need to be changed if the data in column A does not repeat itself. ie It goes from One to Twelve or are random words or numbers?

so essentially it cannot be "generalized" for a big spreadsheet with potentially hundreds of rows and random column A. How will we do that without creating a rule for each line? Will it be macro?
Can the rule be generalized, say, for first line use this rule, for every second line use this and for every third line use this rule? so the colors repeat themselves, without looking for a unique value?