Conditional format based on multiple criteria

I would probably go with =MATCH() rather than countif() (but thats my preference, I dont think there is a logical/technical reason for that)

You could then probably put that into an INDEX() to test for something in the next cell.

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Add an S to the Countif statement to make it multiple conditions. Personally if and when I use Sumif or Countif... it is Sumifs or Countifs, really no need to limit yourself so make it a habit to use those.

Now that is really a side note since you are looking through 2 different ranges for that value. That is, if I read what you put right. The answer is in your question!

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.

Use an AND statement telling it to find a value is just to say that the cell value in that range is >0 in a count if you wrap up your mathematical qualifiers with quotes and throw an & symbol to join the criteria, so ">"&0

=AND(Countifs(sheet2!b1:b10,sheet1!b6)>0,Countifs(sheet2!C1:C10,">"&0)>0)

That should do it...