Conditional format in a range but with two conditions in the row.

[guinch]

I'm looking for some help with some conditional formatting.

I have a sheet where if a value appears in a range of cells then a cell in another column is marked red. If the value does not appear in the range the same cell is marked green.

So I have two CFs:

"=COUNTIF(PDU,A8)=1" turning the cell red

"=COUNTIF(PDU,A8)=0" turning the cell green

This works fine.

However there is another column that determines if the item is actually used or just preliminary booked. So I would like the same red/green cell to turn amber if the red condition is met and the same row that it is met on has a certain value in another column.

So if in cells F3 to F9 any cell contains the value x then another cell turns red. If not it turns green. But if a cell in that range, say f5, does contain the value x then I want to check if B5 contains the value y and if it does then the red/green cell should be amber.

I do not know how easy to understand that is. If it’s not clear let me know and I'll try again.

And thanks in advance for your help.