Conditional Formatting on Booleans

As a model Builder I would like to use Booleans as a Basis for Conditional formatting. 


For example. I have a Boolean/ Checkbox which indicates that not all fields in a new Item/ setting has been filled. I would like to be able to use that boolean directly instead of reverting to a number. 
The advantage would be to save on workspace size,

Community Manager
Status changed to: Needs Community Support

I agree with this request, as a boolean would lend itself nicely to a 2 color formatting rule (eg. true = green, false = blue) and it would avoid having to having to create an essentially duplicate line item (IF bool THEN 1 ELSE 0) solely for the conditional formatting. I have found myself wishing for it often.

Occasional Contributor

I was just about to request this.  This would be really useful as there are instances where you have to start to create line items with a large cell count to achieve it.


I would suggest that we still need to be able the minumum/mid-point/maximum inputs so that we can have a bit of control over the exact coloiur associated with a true or false. 

I agree with this request. Having to have a dummy line item for such a simple use is a massive waste of space.



Master Anaplanner/Community Boss

Ditto. I'm sure Booleans are more efficient too.

Certified Master Anaplanner

Currently if you want to apply a conditional format based on a Boolean value you have to create an additional line item which you then have to put an if statement to test whether it is true or false and return a numeric value more often than not a 1 or 0. It would be more efficient if you could apply a conditional format to a boolean using the underlying 1 or 0 based on the TRUE or FALSE result of the tick box. This would be a great extension to the NUX capabilities which are a significant improvement in terms of look over the classic dashboard.

Community Manager
Status changed to: Needs Community Support
Certified Master Anaplanner

I've often through this!!!  Much of our use of conditional formatting is TRUE/FALSE based so it would greatly simply setup for us if using Booleans was an option.   I think it would also help with auditability.  Thanks for suggesting @nick_barker 

Certified Master Anaplanner

Hi, thumbs up for idea, it would reduce complexity, space usage, and development time, as well as speed up of the models.


Possible duplicate of, can we have it merged ( @Miran )?

Community Manager

Hi @M.Kierepka,


These ideas have been merged.

Users Online
Currently online: 161 members 810 guests
Please welcome our newest community members: