I have a sheet with several hundred email’s, a few of them are missing at the end “.com”.
Is there any way I can search or filter for all cells that don’t have anything after “@gmail”?
@Chocolate Thanks I tried this but the problem is it only shows the category color once that specific email is open, it won’t show when I have the regular list of inbox versus non IMAP will show a small icon of that color to each email