How to change Cell color using formulas

G

Guest

I have a columnA whit 10 numbers, and I have columnB whit 50 numbers, what
formula do I need used to Change the cell of a ColumnA number that appers in
the columnB?
 
B

Biff

Try this:

Assume the range of numbers are A1:A10 and B1:B50

Select the range of numbers in column A.
Goto the menu Format>Conditional Formatting
Formula Is: =MATCH(A1,B$1:B$50,0)
Click the Format button
Select the style(s) desired
OK out

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using wildcards in formulas 4
How to choose maximum value 7
Matching numbers 10
vlookup multiple variables 1
Index/match across multiple columns? 19
Comparing two columns some same some add up to others in column 2 1
Growing Degree Days Formula 4
Create a matrix from data in three column 3

Top