Hello, I was wondering if there is an automatic way to replace text with color. For example, in the image I want to replace all the “y” and “n” with green and red, respectively. Thanks.
Menu Format - Conditional - Condition…:
Condition 1: Cell value - is equal to - "y" - Good
Condition 2: Cell value - is equal to - "n" - Bad
LibreOffice Help on Applying Conditional Formatting.
EDIT: You can hide the cell content by:
- replacing all y by 1, and all n by 0
- choose menu
Format-Cells…-Numberstab, in the field Format Code type a space,OK.
EDIT 2: If do you change y by 1, don’t forget to edit the conditional formatting accordingly.
I Would suggest not to replace the letters, but using conditional formatting. For my needs usually a green or red background fir the cell is all I need, but if you prefer to make y/n invisible select green text on green background and red on red. But remember: These cells are not empty, you just can’t read the contents.
1 Like