How to conditional format cells based on vlookup/match formula

I have a vlookup formula which looks at a table and returns the value of a cell which cross-matches the value in the row and specific column (Not sure I am explaining this correctly). Let me see if I can be more clear. I have test questions which only apply for certain workout types. My formula looks at the workout type (column B) and matches the question ID (Row 4) to the table on sheet 2. Where these intersect, the cell is either blank or contains a "x". I would like to replace the formula with conditional formatting to gray the cell out if where the workout status and question ID intersects is blank.

I have attached a spreadsheet. The top table on Sheet1 contains the results of the vlookup formula. The bottom table on Sheet1 shows how the conditional formatting would look. I need to use conditional formatting because if the question applies to the workout status, the tester will need to input into the cell. If the workout status does not apply, they do not need to answer the question. I need this to be visible so the tester does not waste time answering questions which do not apply.

The table for the vlookup formula is on Sheet2 of the workbook

Please let me know if any additional clarification is needed. AND a big thanks of appreciation for the help/support.

Here you go. See attached. Any good?

I am sorry, I must not have made my need clear. I want to use the formula in the table on the top to produce the result on the bottom. The source data is on Sheet2. So, C5=0, although will work with the formula in the cell, does not meet my needs. I am needing to eliminate the formula in the cell and just have the cell gray out if the cross-referenced cell in Sheet2 is blank. I built the formula so I could try to understand the values returned. Seeing that the formula returns a "zero" for blanks, I am trying to incorporate that into a conditional formatting formula.

Thanks for helping with this. This does give me the desired effect. As the questions (Sheet 2 Headers) and Workout Statuses (Sheet, list in column A) could change in time, this was what was leading me down the path to use vlookup and Match formula. That way, if I am thinking correctly, if the questions or workout statuses change, I will not need to update the conditional formatting. It will work as long as the questions and workout statuses are the same on Sheet 1 and Sheet 2.

For example. I deleted question BANACOL6 from sheet 2. The conditional formatting was showing the results for BANACOL7 on Sheet 1 for Question BANACOL6. When I deleted BANACOL6 column from sheet 2, the conditional formatting appears to be one column off.

Is there a way to turn this formula: =(VLOOKUP(B5,banacol,MATCH($C$4,banacol[#Headers],0))) into a yes/no statement where a result of not equal to "X" gets the formatting? Basically, the formula is saying look up the workout status in cell B5 in the table on Sheet 2 (banacol) and Match the question ID. Where these two intersect, return the value. That is why the chart is showing X if there is an X and a 0 if the cell is blank.

Any other ideas is greatly appreciated.