Conditional formatting formula

[montgai]

What I'm trying to do is check if "C" column "Required" is yes and only then, check if "B" column "Status" is "Empty", then fill "B" column in red.

What I've tried: =AND(C5="Yes";B5="Empty")
I put 5 cause my table starts at that specific row, but it changes row number ok.

But it doesn't work, it fills in red another row, understandable.

Can you help me? Thanks!

[Pepe Le Mokko]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file. Thanks

[montgai]

Here's the file, my bad, i left the old formula there so you can check why it's wrong. Thanks mate

[Pete_UK]

It is because you have defined the refers to range as the whole of column B - set it to =$B$5:$C$17 and ensure that the formula refers to B5 and C5.

Hope this helps.

Pete

[montgai]

The problem is that I don't have a specific range of rows, what i've attached is only an example, I have to refer it for the whole column.

[davsth]

Yes but what is the maximum the column goes to

B:B could be changed to b5:b10000 for example, it does not matter if it is a few rows beyond the end

[montgai]

But I don't think that's the problem, the formula doesn't work, if you check the excel, the last row is "Empty" and "Yes", both conditions are true, so the red filling should be in that "Empty" row, not at the 13th column, which is "Accepted".

[Pete_UK]

If you use the full column then you should select cell B1 and amend the rule so that it refers to C1 and B1.

Hope this helps.

Pete

[montgai]

That's it brother thank you so much!