Hello,
I have a file with two columns
Column A has a list of equipment names, for example: EQ1, EQ2, EQ3, etc.
Column B has serial numbers of equipment from column A.
I need to create a complex conditional formatting, which will check:
If A1=EQ1, and B1<>"HCC*" then make it red,
OR
if A1=EQ2, and B1<>"ABC*" then make it red,
OR
if A1=EQ3, and B1<>OR("CDE*","FGE") then make it red.
And then same thing for A2, B2 cells.
I have thousands of rows in both columns.
I have to check whether selected equipment name corresponds with entered serial name pattern.
I don't know how to do it for each row separately.
I thought of something like:
1st condition: =AND(A1="EQ1",LEFT(B1,3)<>"HCC")
2nd condition: =AND(A1="EQ2",LEFT(B1,3)<>"ABC")
...
But how do I apply this conditional formatting to each row, so that it will compare A2 with B2, A3 with B3, and so on, instead of comparing A1 with B1 in all of the rows?
I have a file with two columns
Column A has a list of equipment names, for example: EQ1, EQ2, EQ3, etc.
Column B has serial numbers of equipment from column A.
I need to create a complex conditional formatting, which will check:
If A1=EQ1, and B1<>"HCC*" then make it red,
OR
if A1=EQ2, and B1<>"ABC*" then make it red,
OR
if A1=EQ3, and B1<>OR("CDE*","FGE") then make it red.
And then same thing for A2, B2 cells.
I have thousands of rows in both columns.
I have to check whether selected equipment name corresponds with entered serial name pattern.
I don't know how to do it for each row separately.
I thought of something like:
1st condition: =AND(A1="EQ1",LEFT(B1,3)<>"HCC")
2nd condition: =AND(A1="EQ2",LEFT(B1,3)<>"ABC")
...
But how do I apply this conditional formatting to each row, so that it will compare A2 with B2, A3 with B3, and so on, instead of comparing A1 with B1 in all of the rows?
