How to make the text color red in LibreOffice Calc (well, or Excel) if the value is less than 100%?

Question

excel

It's just that there are no problems with negative numbers, there is even a built-in format.
But I have the cell format set as a percentage and I need numbers less than 100% to be displayed in red.
How?

Answer 1

In Excel, it's easy - Conditional Formatting, create a rule where for cells with a value less than 1 - red.