So Im struggeling to get this right.
Senario: In cell A1-A10 i need to check its a valid MAC adress.
Cell must only have Capital letters and letters in the cell can only be A to F and numbers 0 to 9 and it needs to be 12 numbers or letters.
If the Cell not is valid I need it to turn red.
AA0032AB3461 Is a valid cell
AA0032AB34G1 is not a valid cell since it holds a G, This cell I want to be red
aa0032ab3451 is not valid since the letters are not capital, This cell I want to be red
Been using =ISNUMBER(SUMPRODUCT(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789ABCDEF")))
But its not what im looking for.
Bookmarks