Excel Formula to format tables

0

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?

    
asked by anonymous 16.05.2017 / 11:27

1 answer

2

I usually use conditional formatting, you can just select the cell and then click on the conditional formatting tab, or select the entire document.

After clicking Conditional Formatting choose Highlight Cell Rules, then just choose the conditions to change the colors automatically according to the word, if it is greater than, less than, equal to, etc. ...

Simple like this

    
16.05.2017 / 12:24