In a range, I try to make a conditional formatting like this :
cell with single space character → background red
cell with double space character → background green
cell with triple space character → background blue
but when I edit, the space become blank.
I try the ’ ’ and " ", but not work, libre replace the condition " " or ’ ’ to blank in condition field.
Is there some alternative to represent “space” character?