conditional formating/if formula plz help!

caroline.vanbommel

New Member
Joined
Aug 21, 2006
Messages
27
I have 2 lists with names and i want the cell to turn to green if the names in the list overlaps. this didnt work because it is names and not values

I also tried using an if formula but it does not work it just keeps on giving me no when there are some that are yes
Formula=
=IF(B3=$A$133:$A$151,"yes","no") and i do the CLT SHIFT ENTER it just says yes to the first one it finds in the list. What am i doing wrong

I dont mind adding a column that then gives me yes or no the i can conditional format those to go green if i see yes.

Thankyou for your time and help
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top