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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]aaa
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]aaa
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]555
[/TD]
[TD]row bg color/text color: red
[/TD]
[/TR]
[TR]
[TD]tttt
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]tttt
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]tttt
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]1212
[/TD]
[TD]row bg color/text color: red
[/TD]
[/TR]
[TR]
[TD]1212
[/TD]
[TD]row bg color/text color: red
[/TD]
[/TR]
[TR]
[TD]tttt
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
[TR]
[TD]tttt
[/TD]
[TD]row bg color/text color: grey
[/TD]
[/TR]
</tbody>[/TABLE]

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.