• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 44
  • Last Modified:

Conditional Formatting in a pivot

Hi,

I have a pivot where I return Yes/No in Col N

I want the corresponding text in cell in Col B to turn red if the N = "Yes"

So if N7=Yes" the text in N7 should be red

Thanks
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
johnb25Commented:
Do you mean B7 to be red if N7 is Yes?

If so, then, with Col B selected:
Conditional Formatting menu/New Formatting Rule/Use a formula to determine which cells to format:
In the formula box enter =N1="Yes"
Click the Format button and then the font colour you want.
This will apply the formatting rule to all of Col B as the pivot table automatically as it expands/contracts.

John
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now