Conditional Formatting - How To Use ICONS?

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
mario.kemptner
Posts: 2
Joined: Sun Feb 16, 2014 9:16 pm

Conditional Formatting - How To Use ICONS?

Post 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
OpenOffice 2.4 on Ubuntu 9.04
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Conditional Formatting - How To Use ICONS?

Post by Villeroy »

It does not work at all. Such a feature does not exist.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Conditional Formatting - How To Use ICONS?

Post 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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
mario.kemptner
Posts: 2
Joined: Sun Feb 16, 2014 9:16 pm

Re: Conditional Formatting - How To Use ICONS?

Post by mario.kemptner »

What is this for then?
n3a5jbwm.png
OpenOffice 2.4 on Ubuntu 9.04
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Conditional Formatting - How To Use ICONS?

Post by RoryOF »

LibreOffice, not OpenOffice. Your signature says OpenOffice 2.4.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Conditional Formatting - How To Use ICONS?

Post by acknak »

AOO4/LO5 • Linux • Fedora 23
Post Reply