Conditional Format based on adjacent cells being equal

Topic

New Reply

Is it possible to conditionally format cells when the adjacent cell is equal to it? For example, if b170 = c170, then format one or both cells with some sort of shading?

If so, how?

Thanks!!
Troy

Reply | Quote

Replies

Troy,

To do this select the cells you wish to highlight then select Conditional Formatting -> Use Formula:
35934-ConditionalFormatting
Enter formula shown above (Use the second one as I entered it first. If you want both cells formatted select the adjacent range and then use the 1st formula shown as it was the second one I entered. I should have changed the order but I already made the screen capture and I’m sure you can adjust. Make sure you enter both = signs in the formula! HTH and Happy New Year! :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

That worked well for the most part. Thanks!! The only downside I found is that this is not case-sensitive. For example, it shows “KM” and “Km” as identical. I still learned a lot, and appreciate the help with this!!

I also tried a different method. In an empty column to the right, I put the following formula:

=IF(B2=C2,TRUE)

Then I filter the TRUEs.

However, this does not appear to be case-sensitive either.

Any ideas on how to make at least one of these methods case-sensitive or provide another method that is?

Thanks!!

Reply | Quote

Actually, I just found a solution that works for the second method using “EXACT”:

=IF(EXACT(B4242,C4242),TRUE)

Is it possible to do that with conditional formatting? I tried but could not get that to work.

Reply | Quote

Just use: =EXACT(B4242,C4242)

Reply | Quote