User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

Skip to content

Conditional Formatting - How To Use ICONS?

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post a reply

Conditional Formatting - How To Use ICONS?

Postby mario.kemptner » Sun Feb 16, 2014 9:20 pm

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
mario.kemptner
 
Posts: 2
Joined: Sun Feb 16, 2014 9:16 pm
Top

Re: Conditional Formatting - How To Use ICONS?

Postby Villeroy » Sun Feb 16, 2014 11:14 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27373
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany
Top

Re: Conditional Formatting - How To Use ICONS?

Postby RoryOF » Sun Feb 16, 2014 11:27 pm

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.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29871
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland
Top

Re: Conditional Formatting - How To Use ICONS?

Postby mario.kemptner » Sun Feb 16, 2014 11:31 pm

What is this for then?

n3a5jbwm.png
OpenOffice 2.4 on Ubuntu 9.04
mario.kemptner
 
Posts: 2
Joined: Sun Feb 16, 2014 9:16 pm
Top

Re: Conditional Formatting - How To Use ICONS?

Postby RoryOF » Sun Feb 16, 2014 11:40 pm

LibreOffice, not OpenOffice. Your signature says OpenOffice 2.4.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29871
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland
Top

Re: Conditional Formatting - How To Use ICONS?

Postby acknak » Mon Feb 17, 2014 12:02 am

Maybe this will help: https://wiki.documentfoundation.org/Faq/Calc/141
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3
Top
Post a reply

Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 1 guest

Apache Software Foundation Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these
Policies and Terms of Use 		Get OpenOffice
Get OpenOffice