I used conditional formatting to have rows of alternating colors. But is there a way to override the assigned color when I want to highlight something in a colored cell?

[MorningLightMountain]

I used conditional formatting MOD(ROW(), 3) = 2 because I wanted alternating colors for better readability. But there are times when I want to highlight text in a colored cell and it wont let me. I’ve been changing the color of the text itself but it doesn’t have the same effect I want. Is there a way to change the settings or the conditional formatting so that I can choose to apply a different background color on an already colored cell? Thanks

[Steph1]

The conditional formatting is the last thing that is applied to a cell, so no, you cannot directly set the color of your cells. But you could add in a separate column a value that will be part of the condition not to format the cells, and then apply the color you want, like in this example:
ExceptionsCF.ods (20.5 KB)

[Lupp]

A somehow more flexible, but less efficient solution relying on an UDF is demontsrated here:
variantListingPaper.ods (15.9 KB)