Hello,
I'm a excel newbie and been studying and learning for the past 2 months, so forgive me if what I ask happens to be stupid
I was trying to create a code that changes the color of a cell if the cell value contains only one word
For example: I have a column with names and surnames, and I want to highlight entries that do not contain a surname (that means it's a single word value) with a RGB color
I'm not a real coder, and all my success attempts in other situations was adapting/merging codes I find in the internet, but I can't find anything related to this. Anyway, my only attempt that didn't result error (but didn't do anything at all) was the following:
I came across somecodes that use the split function to result a single value as an error, then a ISERROR would recognize the cells marked as an error and change the color of it, so I tried to do something similar
If anyone could help me out I'd be extremely thankful!
Pedro.
Bookmarks