Send to a Friend
How can I make this conditional formatting rule in Excel?
Asked by gunther (169)
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
or