I have a conditional format in a cell (b6) that if that value appears elsewhere (sheet2,colum b), the format is applied.
=countif(sheet2!b1:b10,sheet1!b6)>=1
I would like it to only be applied if the exact value appears on sheet 2,colum b, and If there is a value next to it on sheet 2 column c.
How do I add the second condition?

Thanks