Hi everyone,
If we click the values from a pivot table, it will open a new sheet listing the data listed from the value, correct?
Is there a way to apply conditional formatting to the newly opened sheet? What I like to happen is if a colleague double clicked the number of tickets assigned to them, the newly opened sheet will highlight deadlines, etc through conditional formatting.
Is this possible?
If we click the values from a pivot table, it will open a new sheet listing the data listed from the value, correct?
Is there a way to apply conditional formatting to the newly opened sheet? What I like to happen is if a colleague double clicked the number of tickets assigned to them, the newly opened sheet will highlight deadlines, etc through conditional formatting.
Is this possible?