Conditional Formatting TEXT?

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
cmcdar
Posts: 2
Joined: Sat Apr 20, 2019 12:50 pm

Conditional Formatting TEXT?

Post by cmcdar » Sat Apr 20, 2019 12:58 pm

Hello,

I would like to have a negative number appear in RED text.

I have found that I can use conditional formatting to change the cell shading but have not found a way to conditionally format text color.

Is there any way to do this?

Thank you!

martin-k
SoftMaker Team
SoftMaker Team
Posts: 2903
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: Conditional Formatting TEXT?

Post by martin-k » Tue Apr 23, 2019 3:39 pm

There is a much easier way than conditional formatting. Just press Format > Cell or Ctrl+1, select one of the numeric types and choose "Display negative numbers in red". Alternatively, you could choose a custom formatting string (described in the manual).
Martin Kotulla
SoftMaker Software GmbH

cmcdar
Posts: 2
Joined: Sat Apr 20, 2019 12:50 pm

Re: Conditional Formatting TEXT?

Post by cmcdar » Tue Apr 23, 2019 7:37 pm

WOW - that was simple!!!

Thank you so much :D

Post Reply

Return to “PlanMaker 2018 for Windows”