Calc Conditonal Format - Change row color, retain number and date formatting

[gitcalc01]

Hi there

I’m trying to highlight rows of a table based on the value in the first cell on each row, at the LHS.

Problem:
The row has different columns of data including text, date, hours (numbers set to 2 decimal places.)
I only wish to change the background color, not the the cell text properties.

Once the conditional formatting is applied it overides the currency, date and number formatting of the cells in that row. So the colors change as desired, but it seems the color cannot be changed without setting a number format.
How can this color be applied across all these cells without affecting the text/number display formatting?

[LeroyG]

Create new styles inherited from Default style, and only change Background color:, one style for each color. Select this styles to apply in the Conditional Format dialog.

Tested with LibreOffice 7.1.8.1.

[gitcalc01]

Nice suggestion. This is exactly what I tried… many times in fact just to prove I’m not going crazy.
Version: 7.2.5.2 (x64)

When I do this as the attached picture shows the rows with the conditional formatting (33-37) change the dates and the number format of the numbers in the right hand column.
I started with the default style and the only thing I changed was the cell background.

[gitcalc01]

Strange, the initial sheet was only just very recent… only contains minimal data. Bascially just the data in the previous screenshot.

However I tried a new sheet with this formatting and it worked… ???

I can’t explain why…

Thanks again for confirmation.

[LeroyG]

@gitcalc01

I can’t explain why…

Would you share a copy of the offending file, with just one row of data to test? Maybe we can solve what was going behind the date change. To upload a file, edit your question, and use the icon in the middle of the edit toolbar. Thanks.

[draylin]

This topic is kind of old, but since it popped up while searching for a solution to my problem, I want to add my solution:

I just went to the “Standard” template and clicked through all the tabs to use the “Standard” button to reset all values. I also did this for a custom template that my conditional format was based on.