Conditional formatting option of 20 colors excel2010

NikolinoDE 

Hi Nikolino

Thank you for your quick respond. In fact, what I exactly need is very different from that it was complicated and I just want to make it simpler.:)

What I do need is actually;

There is a "Invoice" and "customer name" columns in my excel sheet and another lets say around 20 more. What I need is, with the condition of "invoice" column is not empty I want to color entire row regarding the customer name. For example if the cell of customer name column is "Pepsi" AND at same row an invoice number has entered background colors should be blue for entire row but if in the cell entered "Coca Cola" AND again an invoice number has entered at the same row it should be red. We need this to cross check did we prepared an invoice to the customer. Because each invoice have many rows to organize better we need to color that entire rows regarding that customer name automatically.

We use windows7 and excel 2010.

Thank you for your interest.

tolga