Feb 09 2021 08:16 PM
Hello,
I need to change a certain word in my column C to red if it contains a certain word, like if its positive i need it in red font, then if its negative black font who can assist me with how to do this:?
Feb 09 2021 10:48 PM
@jcordeiro Conditional formatting can do this. Just wondering what font colour you want is the text does NOT contain either of the words "negative" or "positive".
You'll find the Conditional Formatting icon on the Home ribbon.
(Screenshot taken on a Mac, but similar on a PC)