Conditional formatting with formulas

You need to change the CF formula on the BD sheet to this:

=OR(ISNUMBER(SEARCH("X",C6)),AND(ISNUMBER(SEARCH("X",C6)),ISNUMBER(SEARCH("Y",C6))))

You need to set up a similar formula on the other sheet.

Hope this helps.

Pete

EDIT: Oh, by the way, you may need to change the commas ( , ) to semicolons ( ; ), depending on your regional settings.

Pete

Thank you for your help,

Your solution worked for me in the BD sheet, but it did not work in the other one.

Can I make a test if the cell in BD sheet is FILLED WITH YELLOW Then fill it with yellow here too ?

You can't refer directly to another sheet with Conditional formatting. You could have a (regular) formula within a column of the second sheet which refers to the BD sheet, and then you could refer to that within your CF conditions on the second sheet.

Hope this helps.

Pete

Thank you so much for your time.
But sorry I did not completely understand your words as I am still a beginner.

But thank you I apreciate your help.

I am trying with VLOOKUP

Because in the first sheet I have a list, a list of many letters which are located in the BD, But actually I don't need the letters, I need the type of the selected letter from the list,

EXAMPLE :

I choose the letter "A" from the list, the formula should :

1- Go to the BD sheet
2- see the type of the selected letter
3- if the type name contains "X" , then the cell of the selected item from the list get filled with yellow

It's complicated

Problem solved

ISNUMBER(SEARCH("X",VLOOKUP(C9,BD!$B$6:$C$24,2)))

Thank you.