Conditional Format in Total

tompatrick.ting
Contributor

Conditional Format in Total

Hello,

 

Please help how can I apply a conditional format in my line item for total without putting a summary in the module blueprint.

 

Please see attached picture.

tompatrickting_0-1600233282973.png

 

Thanks advance for the help.

Tom

 

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Conditional Format in Total

@tompatrick.ting 

 

See if this helps

 

1. Change the Summary Settings of your line item from None to Formula

2. Create boolean formatted line item,check all the leaf items and keep the summary as NONE

3. Apply this as DCA to your line item

Misbah_0-1600246084076.png

Misbah_1-1600246107016.png

 

 

View solution in original post

4 REPLIES 4
Misbah
Moderator

Re: Conditional Format in Total

@tompatrick.ting 

 

Summary is Important. You will have to change the summary settings from NONE to Formula or anything but NONE

tompatrick.ting
Contributor

Re: Conditional Format in Total

 

Hi @Misbah, Is there other way I can put a conditional format without changing my Summary settings? We don't want to show the list name in the last row.

 

Thanks,

Tom

Misbah
Moderator

Re: Conditional Format in Total

@tompatrick.ting 

 

See if this helps

 

1. Change the Summary Settings of your line item from None to Formula

2. Create boolean formatted line item,check all the leaf items and keep the summary as NONE

3. Apply this as DCA to your line item

Misbah_0-1600246084076.png

Misbah_1-1600246107016.png

 

 

View solution in original post

tompatrick.ting
Contributor

Re: Conditional Format in Total

Thanks @Misbah for helping, this one works.