SoftMaker.com

English-Language Support
It is currently Sat Dec 20, 2014 9:36 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Conditional Formatting
PostPosted: Wed Apr 15, 2009 11:44 pm 
Offline

Joined: Wed Apr 15, 2009 11:35 pm
Posts: 1
Can somebody explain how to use the "between" & "not between" with the "and" . What exactly does this do in conditional formatting? An example would be ideal. Regards Radioboyo.


Top
 Profile  
 
PostPosted: Mon Apr 20, 2009 1:57 pm 
Offline
SoftMaker Team
SoftMaker Team

Joined: Wed Apr 09, 2008 7:26 am
Posts: 5632
Location: Nuremberg
Hello,

with the conditional formating you can format cells in special cases. I attached a sample file. In that file the cells A1, B1 an C1 are formatted with "Cell value" | "between" | "1" | and | "2" and a blue background with white text color.

That means, if the value in the cell is between 1 and 2, PlanMaker formats the cell with a blue background and with white text color. that happens in the cells A1 and A2.

The cell A3 also contains these formating "rules" but the value is 3, so nothing happens here.


Attachments:
conditional formating.pmd [12.5 KiB]
Downloaded 169 times

_________________
Sven LeƟmann
SoftMaker Software GmbH
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group