[Solved] Formatting...

Discuss the spreadsheet application

[Solved] Formatting...

Postby No3Jacks » Mon Jan 22, 2018 9:20 pm

Is there any way to automatically format the result in column D to change the text color to RED when the result is $14.99 or lower. I've intentionally changed the font color to red in the example. I'm just wondering if there is a way for it to automatically change to RED when the result is $14.99 or lower? If the result is $15.00 or greater leave it BLACK.
Attachments
Format Question.ods
(13.36 KiB) Downloaded 6 times
Last edited by RoryOF on Mon Jan 22, 2018 10:00 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
OpenOffice 4.1 on Windows 7
No3Jacks
 
Posts: 11
Joined: Mon Aug 25, 2014 11:46 pm

Re: Formatting...

Postby Zizi64 » Mon Jan 22, 2018 9:36 pm

You need create a custom cell style with red characters, and apply it by the "Conditional formatting" feature.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.1 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6279
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formatting...

Postby Zizi64 » Mon Jan 22, 2018 9:50 pm

...Generally, it is better to use the Styles instead of the direct (manual) formatting properties.
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.1 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6279
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: unspoiled and 37 guests