# Excel - COLUMN Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.