Is there any formula to string the colors of a table? I do not want the "normal" (eg red | white | red). What I intend is always that the name of a certain cell is equal, then the background is of color A, when the name of the cell is different then it changes to the color B, when the name changes again then the color returns to be the color A and so on.
Table example.
Teste X B A T -> cor A
Teste f s f g -> cor A
ALPHA f s f g -> cor B
ALPHA g g h r -> cor B
ALPHA f s f g -> cor B
Beta G A f g -> cor A
.......
The value to compare is from the first column by the value of the first column of the previous row.
Is it possible?