I have an issue with my excel conditional formatting. It seems to work only on one column, regardless if its moved and the columns in the rule changed. My rule is as follows, I tried to space it out to make it more readable but its obviously not in actual rule box:
=IF(EXACT(BQ2,"Diamond"), //start if
OR(ISNUMBER(SEARCH("CRATE%",BM2,1)),ISNUMBER(SEARCH("CDMG%",BM2,1))), //if true
IF(EXACT(BQ2,"Square"), //if false start another if
OR(ISNUMBER(SEARCH("RES%",BM2,1)),ISNUMBER(SEARCH("CDMG%",BM2,1))), //if true
IF(EXACT(BQ2,"Triangle"), //if false start another if
OR(ISNUMBER(SEARCH("CRATE%",BM2,1)),ISNUMBER(SEARCH("RES%",BM2,1)))))) //if true
My rule is that if the cell's value is "Diamond" the words "CRATE%" and "CDMG%" will trigger the cell to turn blue,
if "Square" the words "RES%" and "CDMG%" will trigger the cell to turn blue.
if "Triangle" the words "RES%" and "CRATE%" will trigger the cell to turn blue.
The three Shape values and what words they check for are on the same row. They change per row but only between those three shapes and few words.
This same format occurs on the next two columns as well, however, the next two columns, which receive the same rule and adjusted column names, will not work.
Am I doing too many calculations or is my rule wrong to begin with or is it another issue all together?
Here is a screenshot of the data in the sheet. As you can see, column BQ works fine, but even with the same rule on BR and changing BQ2->BR2 and BM2->BN2, the second row, will not work. Neither will the third. The top Formatting Box is for the first column, and the bottom for the second column.
The second rule is just a NOT version of the first rule, designed to reverse the blue box when it is "Correct." Im sure this is bad way to reverse it but that is not what Im here for.
