Conditional formatting, based ot multiple values in 2 cells.

Hello,

I am stuck with the following issue:

I need to create the following formatting:

if in cell A1 one of the values A, B or C is present and in cell B1 one of the values 21, 22, 23, 24 or 25 is present, paint cell B1 in red.
The values are examples, but if I have to set a separate rule for every pair of the data range I have in these cells, I have to create more than 100 separate rules.

The single rule for every pair I have used before is =(A1="A")*(B1=1)=1 and so on. But this was when I had to compare single value in cell A1 with several values in cell B1.

Thank you in advance for the help.

Perhaps something like:

Formula:

Please Login or Register  to view this content.

Tried that - not working

Could you explain what you mean exactly by "not working"?
From your description of the problem in your original post, that solution works perfectly for me.

Perhaps if you post a sample workbook it would be easier to help you out.

BSB.

I gave 21-25 as an example for the second cell values. The actual numbers are not subsequent. The values in the 1st cell are of the type N1, N17, N3 or just numbers. Same goes for the second cell. I apologise if I have misled you - I just used example values.

=AND(OR(A1="N3",A1="N14",A1="N17"),AND(B1=21,B1=2,B1=3,B1=4,B1=5,B1=11,B1=12,B1=17,B1=18,B1=19,B1="N1",B1="N9",B1="N11",B1="12",B1="13"))

This is one of the formulas I need with the correct values. The error message is "Incorrect formula"