Conditional Formatting - 3 nonconsecutive columns - odd one out

louisepr

New Member
Joined
Nov 5, 2020
Messages
25
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi :)
I am trying to compare the text values in 3 columns (G, I and J) and only highlight the value that is different. I would like to use conditional formatting and a "simple" formula if possible

eg
1608179372606.png


Thank you in advance
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,645
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Select columns you want and Go to Conditional Formatting ; Manage Rules ; Use a formula to determine ... and Select first Cell and first column ( I think it is G3) and add equal sign = and Then Select first Cell and Second column ( I think it is I3) ; finally go to format and choose what you want.
IMPORTANT: check when you select cells don't import cell address with $ sign and if have, remove it.

If you want formula for Column J :
At J3 input and drag it down:
Excel Formula:
=IF(G3=I3,"Same","Different")
 

louisepr

New Member
Joined
Nov 5, 2020
Messages
25
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Thank you for answering me and apologies for the delay in responding to you - I can only test on Thursdays :)

From what I can tell, this is only telling me if 1 cell matches another, not highlighting which of the 3 cells are different?
 

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,645
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Use this formula Without$ at Conditional formating:
Excel Formula:
=OR(G3<>I3, I3<>J3, G3<>I3)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,777
Messages
5,626,820
Members
416,202
Latest member
donya ba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top