Link to home
Create AccountLog in
Avatar of ellsworth2000
ellsworth2000

asked on

How can a button/macro be created to search another column in Excel 2010

Good Day Experts,

In Excel 2010 i'd like to compare data from 2 columns and if data in column A isn't found in all of Column B then the cell of  data within Column A turns red.  So the data in column A might not be on the same row as the data in column B but if that data is somewhere in Column B then the data doesn't turn red.  If Data in a single cell within Column A is not anywhere in Column B then that cell of data turns red.

Is this possible?

many Thanks,

Ellsworth
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
The previous comment assumes that your data starts in A1. If not then change the a1 in the given formula to whatever it is.
Avatar of ellsworth2000
ellsworth2000

ASKER

ok so i gotta figure out how to make something else work before i can do this

the list i'm comparing to has names as firstname.lastname in column B and Column A has firstname, lastname

I'll create another question so i'm not putting two questions in one
WOOOWHOOOO!!! it worked!!! Thank you so much!!!