Conditional formatting

[numaiu]

Hello.

I want to make a table that autoamticly changes the row's background color/text color every time the text from the first column changes.
It should look like this:

aaa	row bg color/text color: grey
aaa	row bg color/text color: grey
555	row bg color/text color: red
tttt	row bg color/text color: grey
tttt	row bg color/text color: grey
tttt	row bg color/text color: grey
1212	row bg color/text color: red
1212	row bg color/text color: red
tttt	row bg color/text color: grey
tttt	row bg color/text color: grey

<tbody>
</tbody>

Can this be done ?

 

[Joe4]

Welcome to the Board!

One way would be to use a "helper" column (which you can hide of you want).
Let's say that your data starts in cell A1.
Then in B1, you could enter 1.
Then in B2, enter this formula:

=IF(A2=A1,B1,B1+1)

and them copy down for all rows.

Then, you could use highlight cells A1 to the bottom, and use these Conditional Formatting formulas:

Condition 1
=ISODD($B1)
choose grey color

Condition 2
=ISEVEN($B1)
choose red color

This should do what you want.