How to set up conditional formatting based on another tab

[kyber]

Hi,
In Sheet2 I have a Pivot Table with a bunch of names in Column A. I would like, that when there's something written (doesn't matter what) in Sheet1 under Column G (Notes) that the respective person in the Pivot Table is highlighted.

I have highlighted a cell as an example of what I'm hoping to accomplish through conditional formatting.

Sorry if this was poorly explained.

[kyber]

This is my current attempt at the formula. Perhaps I'm doing it wrong or choosing the wrong formula.

=A5=INDIRECT("+Sheet1!$G$2:$G$351"&CELL("<>",A5))

[popipipo]

Please Login or Register  to view this content.

Try this formula in CF

[kyber]

Genius, this works for the mock! Sadly not for the sheet that I'm working on, but I can try to figure out why. Thank you so much!

[kyber]

I figured out why it didn't work. Now it does. Thank you again!

[protonLeah]

this one works on test sheet:
=OFFSET(sheet1.notes,MATCH($A5,sheet1.names,0),0)<>""
using name range vs table names

[kyber]

I'm not getting it to work.

[kyber]

@popipipo, why is it that if there are two entries for an individual that it doesn't pick up if there's a note for their second entry?
Attachment 761311
Attachment 761312

Let me know if I need to reattach the mock sheet. I did manually enter that row in to test it out and to show it.

[JeteMc]

Selecting either of the attachments in post #8 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
I suggest uploading an .xlsx file utilizing the instructions in the banner at the top of the page.
Let us know if you have any questions.