Page 1 of 1

Conditional Formatting - How To Use ICONS?

Posted: Sun Feb 16, 2014 9:20 pm
by mario.kemptner
Hey guys,

I've been trying to figure out how to use icons with conditional formatting. When value X in Cell D4 is less than 40, I want the green traffic light icon to show, for example.

How does that work?

Thanks,
Mario

Re: Conditional Formatting - How To Use ICONS?

Posted: Sun Feb 16, 2014 11:14 pm
by Villeroy
It does not work at all. Such a feature does not exist.

Re: Conditional Formatting - How To Use ICONS?

Posted: Sun Feb 16, 2014 11:27 pm
by RoryOF
Your nearest solution might be to either set a cell to green or red (traffic light colours) or to change the background of the key cell. I know the subject of coloured bakgrounds and styles comes up regularly on the Forum. I don't do Calc, so can't help beyond this suggestion.

Re: Conditional Formatting - How To Use ICONS?

Posted: Sun Feb 16, 2014 11:31 pm
by mario.kemptner
What is this for then?
n3a5jbwm.png

Re: Conditional Formatting - How To Use ICONS?

Posted: Sun Feb 16, 2014 11:40 pm
by RoryOF
LibreOffice, not OpenOffice. Your signature says OpenOffice 2.4.

Re: Conditional Formatting - How To Use ICONS?

Posted: Mon Feb 17, 2014 12:02 am
by acknak