Conditional Formatting Issue

[Fudging]

Hello,

I am trying to figure out a way to work conditional formatting in my specific case. In one tab, I have a table that contains a column with number IDs and there is another column in that table that indicates if the project is complete. In the second tab, we have the same table, just without the column that indicates if the project is complete. What I am trying to do is the following: in tab 2, I want to change the cell color in the number IDs if in tab 1, the project is complete.

As you can see in the picture, the Tab 1 table highlights all cells in orange if the project is complete, pretty easy conditional formatting. Again, what I would like to do, assuming that the Tab 2 table was in a different tab, is to highlight the project IDs in that same color, if the project is complete according to the Tab 1 table.

I was wondering if this is possible with regular conditional formatting or does this need to be done in VBA?
(If it does require VBA, the color code is 255, 192, 0)

Thanks for the help

 

[Joe4]

You can use Conditional Formatting just fine.

Let's say that the data on a sheet named "Tab 1" is in the range A1:H12 (where row 1 is the header, and your IDs are in column H).
And let's say that the data on a sheet named "Tab 2" is in the range A1:G12 (where row 1 is the header, and your IDs are in column G).

Then select rows 2:12 on Tab 2 and enter this Conditional Formatting formula:

=COUNTIFS('Tab 1'!$H:$H,$G2,'Tab 1'!$A:$A,"Yes")>0

and choose your desired color.

 

[Fudging]

Sweet, worked perfectly, thank you very much

 

[Joe4]

You are welcome.