You can do 4, of course (base format plus 3 conditional formats).

I understand precisely what you want However, the problem is that a cell stores a number or a letter, or several of one or the other; or a formula. It does not store anything else. Things like color, font, etc. are metadata that are not directly accessible inside the cell.

The way to do the row is, of course, with a conditional format on the entire row

Do a formula-based conditional format (not just a IF CELL = VALUE format) where you say:

=IF($A1="BLUE",TRUE,FALSE)

as the conditional format condition (I don't know OO specifically, but it tends to imitate excel in such).

Then apply that to the entire row. (Replace A1 with the value driver.)

I understand precisely what you want However, the problem is that a cell stores a number or a letter, or several of one or the other; or a formula. It does not store anything else. Things like color, font, etc. are metadata that are not directly accessible inside the cell.

The way to do the row is, of course, with a conditional format on the entire row

Do a formula-based conditional format (not just a IF CELL = VALUE format) where you say:

=IF($A1="BLUE",TRUE,FALSE)

as the conditional format condition (I don't know OO specifically, but it tends to imitate excel in such).

Then apply that to the entire row. (Replace A1 with the value driver.)

## Comment