Using conditional formatting to change the number format

edit

Thanks @ebot for the quick answer. That worked but only with the underlying default format. As soon as I give the cell another Number format this overrides the Conditional format.

I'm not sure how to return the spreadsheet.

Using a style to give the format instead direct format, doesn't work for you.

@m.a.riosv using a style in the conditional formatting works until you allocate a number format. Then the number format takes priority over the conditional format. Colours remain as per conditional format.

As @m.a.riosv writes, only use styles and no direct formatting.

If you want to upload a sample file, edit your initial question and use the "paper clip" icon to insert a file. Make sure that the file is reduced and anonymized as much as possible. Thank you.

As soon as I give the cell another Number format this overrides the Conditional format.

Are you working with .xlsx file format? What you describe only works with .xlsx. Using .ods file format, I could not manage to override any applied Conditional Formatting.