Not sure if this is what you are looking for, but I would try:

=if((Sheet1!A2=Sheet2!D6),D10,"FALSE")

This would check if cell A2 in Sheet1 is equal to D6 in Sheet2, and if it
is, return the value that is in D10. If not, it will return the word FALSE.

Hope this helps!



"conditional format if cell contains word" wrote:

IF A CELL ON ONE WORK SHEET MATCHES ANOTHER WORKSHEET

for instance if A2 on worksheet one = D6 on Worksheet 2 then I want A4 on
worksheet one to equal D10