In Excel you are limited to 3 conditional formats per cell. Therefore, if
you had more than 3 suppliers this would not work for you anyway.

However, there are a few other alternatives.
1) Just sort the spreadsheet by supplier so its easier to see the supplier
groupings.
2) Use Excels autofilter functionality (menu path Data / Filter /
Autofilter) and use the drop down arrows to just view the supplier you want.
3) Another option would be to create another cell that would contain the
supplier that you want to view (lets say cell E1). You could put in the
conditional formats for all the cells in column A that contain supplier that
if the cell in column A equals the cell in E1 to hightlight green. If not
highlight grey.

Hopefully one of these options will work for you.

Thanks,
Bill Horton

"looksmart5000" wrote:

Hi, I work with invoices from my suppliers to make the payments and I put in
excel sheet with invoice number and supplier like

A2: supplier 1 - inv. number
A3: supplier 1 - inv. number
A4: supplier 2 - inv. number
A5: supplier 3 - inv. number

What I'm trying to made is shade the rows from supplier 1 as white, supplier
2 as gray 25%, supplier 3 as white or any other color. I have many suppliers
and vary from month to month. The conditionnal format doesn't find a way to
solution. I have tried to put a condition IF(A2<A1) gray else white, but in
the next row the A3=A2 it will paint as white instead gray. My objective is
distinguish the suppliers at a glance. Thanks
--
With best regards,
Looksmart5000