Highlight Cells IF Specific Conditions Met

[rprieto7]

Hello,

I work for a public school. We are trying to upgrade our attendance call log spreadsheet, and I was tasked w/ doing it as the tech-savvy guy. I built out the entire sheet by myself, but I have hit a snag in finishing this project.

I created a bunch of pivot tables (every two weeks of school). If a student misses 3 or more days in 2 weeks, then their name gets highlighted on the pivot table. If their name gets highlighted in that specific pivot table, then I would like for that name to be flagged on the main table.

How do I highlight a cell if it matches another name in that same sheet AND if that name has previously been highlighted in the pivot table?

Thank You!

 

[Fluff]

Duplicate to: Highlighting Cells IF Conditions Met

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.