Question description:
This user has given permission to use the problem statement for this
blog.
Say I have 2 columns - Column A has numbers 1-100 and Column B has ONLY the numbers 5,19, and 79. How would I highlight the Column A numbers that are NOT in Column B?
Solved by B. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/11/2017 - 02:30
Hello :)
Excelchat Expert
20/11/2017 - 02:30
So you want to highlight only the numbers that aren't 5, 19, and 79?
User
20/11/2017 - 02:31
yes
Excelchat Expert
20/11/2017 - 02:31
Okay, so you would create three different conditional formating formulas.
Excelchat Expert
20/11/2017 - 02:32
Is that how column B is setup?
User
20/11/2017 - 02:32
yes
Excelchat Expert
20/11/2017 - 02:32
Okay, perfect.
User
20/11/2017 - 02:32
I have column titles is all
Excelchat Expert
20/11/2017 - 02:33
Sure. One moment and I will show you how to do this.
Excelchat Expert
20/11/2017 - 02:33
You may only need one formula.
Excelchat Expert
20/11/2017 - 02:40
Looks like you will need 3 separate formulas.
User
20/11/2017 - 02:41
ok, I tried doing just one conditional formula but it wouldnt seem to work
Excelchat Expert
20/11/2017 - 02:44
It's working on my end.
Excelchat Expert
20/11/2017 - 02:44
I"ll send you the link soon.
User
20/11/2017 - 02:44
great, thank you for your help
User
20/11/2017 - 02:45
will this work only on google sheets? Or will the same process work on regular Microsoft Excel
Excelchat Expert
20/11/2017 - 02:45
https://docs.google.com/spreadsheets/d/1L_lQwT4Gmc7GoaAujG5Gi3UoP3PY9Tp5mRPadmeSvHE/edit#gid=0
Excelchat Expert
20/11/2017 - 02:45
It will work with Excel also.
User
20/11/2017 - 02:45
Thank You very much
Excelchat Expert
20/11/2017 - 02:46
You're very welcome.
Excelchat Expert
20/11/2017 - 02:49
This is complete.
Excelchat Expert
20/11/2017 - 02:49
I managed to get it to work with only one formula
Excelchat Expert
20/11/2017 - 02:49
=and($A1<>$B$1,$A1<>$B$2,$A1<>$B$3)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.