Color bunch of rows with the same key value

[SHIR0206]

Hello,

If a bunch of rows contain a certain key value, I would like to color all the rows in blue. And then if a bunch of rows contain a certain key value, I would like to color all the rows in white. And so on, blue-white-blue-white untill the end of the table.
What is the best automatic way to do so? (Office 2010).

For instance, in the following example, my key value is "COUNTRY".
If the cell above contains the same country-value, color the whole row in the same color as above.
Else, color the whole row in different color.


ID | NAME | AGE | COUNTRY
105 | BOBO | 22 | USA >> Whole row is WHITE
106 | MOMO | 52 | USA >> Whole row is WHITE
107 | LOLO | 63 | FRANCE >> Whole row is BLUE
108 | POPO | 21 | INDIA >> Whole row is WHITE
109 | KOKO | 12 | ITALY >> Whole row is BLUE
110 | JOJO | 58 | ITALY >> Whole row is BLUE
111 | TOTO | 47 | ITALY >> Whole row is BLUE
112 | FOFO | 36 | MEXICO >> Whole row is WHITE
113 | DODO | 21 | MEXICO >> Whole row is WHITE
114 | ZOZO | 52 | THILAND >> Whole row is BLUE
115 | SOSO | 19 | GERMANY >> Whole row is WHITE

[FDibbins]

Hi, welcome to the forum

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.

https://www.excelforum.com/excel-cha...key-value.html