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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,641
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,641
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,680
Messages
5,626,247
Members
416,168
Latest member
DROP_DATABASE_MrExel

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