EXCEL NEWB.....Change cell color based on text in a cell on another sheet

Hi everyone. I'm an absolute newb when it comes to trying to use excel for things, but i figured this would be a good place to start. What I need to do is change the color of a cell between red and green based on a cells text on another sheet. Attached is the specific workbook I'm trying to do this on. I want to change cell B2 on PID Tags 1-6 to green if the value in cell H7 on PID List Page 1 equals either "CBV" or "EB". At the same time if the H7 cell equals "ZE" I want to make it filled red. I have read all the instructions for it and I guess I just can't get it. I am using Excel for Mac 2011 if that makes a difference. Thanks in advance for any help. And if possible give me a dumbed down version of how to do it.

Example Sheet.xlsx

Hi, welcome to the forum

I dont use mac, so Im not sure if this is the issue or not. you can only directly feference another worksheet using Conditional Formatting, from vesion 2010 onwards. 1 way to text this is to use this formula directly in CF...and it it doesnt work, try option 2.

As a start, if your cells will only ever be green or red, use regular formatting to make the cell GREEN and then change that with CF to red.

Option 1...
=OR('PID List Page 1'!H7="CBV",'PID List Page 1'!H7="EB")

Option 2
In a cell on PID Tags, reference back to ='PID List Page 1'!H7 (you can hide this if you want)
then the CF formula changes to...
=OR(B1="CBV",B1="EB")

Thank you so much for the kind words and feedback (despite my really bad typing and spelling lol), always appreciated