Skip to main content

Currently conditional formatting is universal across a document.  But sometimes you want to show data one way on one tab, and another way on another tab.  Think current & future states.  On current state I might want to show a “sunset” application as yellow.  On future state I might want to show it as red.  But currently this is impossible since you cannot set the formatting specific to separate tabs.

Good question, you can accomplish what you’re looking to do by making the conditional formatting shape specific. This will allow you to apply different conditional formatting to different shapes on different pages. 

 

Next to each rule, hit the 3 dots and select unapply. And then select the shapes you want to apply the rule to and then click on “apply” again for that specific rule. Give that a go and let us know.

 

 


I was coming here to answer too! You can alternatively use the “apply to current page” option in the CF panel. See my screenshot:

 


Reply