Using Excel 2013 I'm looking to apply a conditional formatting rule to all cells in a range of a column that do not contain SD followed by two numbers, so an example would be SD01 or SD32. The column of interest is K.
I've thought I would deal with the two characters first then figure out how to add the two digits.
I came up with a formula that ignores blank cells, then highlights the ones that have SD.
The first formula I tried that highlights the correct ones (the ones with SD):
=IFERROR(IF(ISBLANK(K12),"",(IF(SEARCH("SD",K12,1),1,0))),"")
I thought reversing the results of the SEARCH formula would have solved that problem:
=IFERROR(IF(ISBLANK(K12),"",(IF(SEARCH("SD",K12,1),1,""))),1)
If this is simpler with Office 2019, please mention it.