Send to a Friend

gunther's avatar

How can I make this conditional formatting rule in Excel?

Asked by gunther (169points) December 4th, 2014

I want to make a formatting rule in Excel that will change the color of the text in a cell only if it is different than the text in a cell of a different column in the same row. So basically, if A1 and B1 are the same, I want them to be the same color; but if they’re different, I want Excel to automatically change the color of B1.

Here’s an example of what I want it to look like.

I’m new to Excel and so far I’ve been able to find everything through Google and Youtube, but I haven’t been able to figure this one out. It’s probably simple, but I can’t seem to find a good explanation online.

Using Fluther


Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.