Letter Conditions

[JoeExcelHelp]

I realize this isnt the correct format but i hope it gives you an understanding.. trying to create a conditional format based on the existence of 2 unique letters in a cell.. can you assist?

Code: Select all

=IF(ISNUMBER(and(SEARCH("T",G13),search("B",G13)),TRUE,FALSE)

[HansV]

Try

=AND(ISNUMBER(SEARCH("T",G13)),ISNUMBER(SEARCH("B",G13)))

[JoeExcelHelp]

It works but I seem to have another formula influencing the one you just provided

Cell value G13 = B1T1
This is another formula is my condition:

Code: Select all

=IF(ISNUMBER(SEARCH("B",G13)),TRUE,FALSE)

This the one you just provided:

Code: Select all

=IF(AND(ISNUMBER(SEARCH("T",G13)),ISNUMBER(SEARCH("B",G13))),TRUE,FALSE)

For some reason it keeps defaulting to the first condition and it seems odd because the first condition mentions "B" only and the 2nd condition mentions "B and T"

[HansV]

Select the cell, then select Conditional Formatting > Manage Rules...
Switch the order of the rules.

By the way,

=IF(ISNUMBER(SEARCH("B",G13)),TRUE,FALSE)

can be shortened to

=ISNUMBER(SEARCH("B",G13))

and

=IF(AND(ISNUMBER(SEARCH("T",G13)),ISNUMBER(SEARCH("B",G13))),TRUE,FALSE)

can be shortened to the formula that I posted:

=AND(ISNUMBER(SEARCH("T",G13)),ISNUMBER(SEARCH("B",G13)))