Conditionally format cells with date?

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

Moderator: SoftMaker Team

Post Reply
R3gi
Posts: 4
Joined: Sat Oct 14, 2017 12:14 pm

Conditionally format cells with date?

Post by R3gi » Sat Oct 14, 2017 12:22 pm

Hi,
please, is there a way to conditionally format cells in selected range which contain dates that are greater or equal to e.g. 31.12.2007? That means e.g. 13.02.2008 would be green and 13.02.2005 would be red. Cells are formatted to date value "DD.MM.YYYY;@".

Thanks for any help!

R3gi
Posts: 4
Joined: Sat Oct 14, 2017 12:14 pm

Re: Conditionally format cells with date?

Post by R3gi » Mon Oct 16, 2017 8:41 pm

Solved. It can be done e.g. using the format only cells that contain function together with DATE formula ("=DATE(2006;31;12)"). It's surprising that it isn't included as a default feature between the date rules…

Post Reply

Return to “PlanMaker 2016 for Windows”