calc icon set formula

[nametaken234232]

I’m trying to get the conditional formatting to work with the icon set.

For icon sets that are in the same cell it works nicely

so if I have A1 with a value of 0 and A2 with a value of 1 it will show a traffic light depending on that value.
What I’m trying todo is to have a traffic light in a cell without text in it, so make it dependent on another cell (which I can hide then).

So I have a colum A and in those cells is either 0 , 1 , or something else
In column B I want to have a traffic light depending on the value of the Cell left to it from column A.

So I go to B1 → conditional formating → Icon set, change Percent into “Formula” and there starts the problem… whatever I try there won’t work so formula “=A1” or “IF(A1>0)” etc… I’m sure I’m doing something stupid… any idea?

[LeroyG]

• Type in A1 the values (in my example they are 0, 1 and 2).
• In B1 imput the formula =A1.
• For B1 choose menu Format - Cells… - Numbers tab, and in Format code field type a no-break space (Alt+0160¹); this will show an “empty” cell.
• To set conditional format, choose Format - Conditional - Icon Set….
• In the yellow light field type 1, and choose Value.
• In the green light field type 2, and choose Value.
• OK.

See sample file.

¹ To obtain the no-break space you can also previously edit a cell, type U+00A0 and inmediatelly press Alt+X, select and copy this space to paste later in Format code.

Made with LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.

---

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark () to the left of the answer that solves your question.