[Solved] Formatting...
[Solved] Formatting...
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 53 times
Last edited by RoryOF on Mon Jan 22, 2018 10:00 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Reason: Added green tick [RoryOF, Moderator]
OpenOffice 4.1 on Windows 7
Re: Formatting...
You need create a custom cell style with red characters, and apply it by the "Conditional formatting" feature.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Formatting...
...Generally, it is better to use the Styles instead of the direct (manual) formatting properties.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.