Apply conditional format on Top Level Item

Highlighted
Contributor

Apply conditional format on Top Level Item

Hi all,

Can someone teach me how to apply the conditional format to only the Top Level Item?

Picture below is showing that I am trying to highlight the lines that that not equal to 100%(I have a line item with the equation that if total All Station is =1 then 0 else 1). But I only want to apply the condition format to the Top Level Item, which ic All Station in this situation. Can someone share some pointers on how I should approach with this?

 

jimfeng5_2-1602182677486.png

 

Thanks,

Jim

 

 

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Apply conditional format on Top Level Item

Highlighted
Contributor

Re: Apply conditional format on Top Level Item

Thanks Rob, that was a great start.
On top of what Chris had, I created additional line items so that I only highlight the % that are not equal to 100%, here is a screen shot of what I did:

My Conditional Format is based on "Test 3" line item, I will be trimming this module to reduce line items.

jimfeng5_0-1602195730614.png