I have a sheet with rows in following format
Image - Bandname1
Image - Bandname2
Image - Bandname3
Text - Bandname1
Text - Bandname2
Text - Bandname3
I need to compare only the words after "Image - " to words after "Text - "
and if they are the same, highlight the lines.
Basically this tells me that a band has both images and text,
But if it's not highlighted then I know that the band has only text and needs images, or has images and needs text.
Thanks!
Bookmarks