Excel Formatting for certain text value

Occasional Visitor



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:?

1 Reply

@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 2021-02-10 at 07.46.49.png

(Screenshot taken on a Mac, but similar on a PC)