Apply conditional format on Top Level Item

jimfeng5
jimfeng5
in Modeling

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

 

 

 

Tagged:

Best Answer

Answers

  • jimfeng5
    jimfeng5

    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

     

Categories