Use index/match or vlookup to conditonal format table, based on criteria

Hello,

I would like to apply conditional formatting in the attached table, so as to see whether or not im inputting the codes (X1-X5) correctly.
I want to apply the conditional formatting in the "DATA" sheet.
I am inputting a code, for example 1001 and then i am filling in the X1,X2,X3,X4 and X5.

In the "criteria" sheet, next to each code there is a letter for each X1-X5, which means:
Y=Yes code is required
N=Not required
O=Optional

So, i want to conditional format the table in the "DATA" sheet on X1-X5 columns, under these 3 criteria.

Thanks in advance for reading this.

i want to use three colors on DATA Sheet based on the Y, N and O on the Criteria Sheet

Hello and thanks for your reply.
Please find attached what i want to achieve with the conditional formmating.
I want to use cond.format so as where in x1-x5 tables there is a Y=green color, N=red color, O=yellow color.
All these colors to appear in DATA sheet, so as to have the information based on colors, whether or not i should put information on X1-X5 columns.

Can this be done with conditional formatting?

bump, any ideas about the formula and if this is possible?

thanks a lot, works like a charm!