Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comapre two lists
Hi
once i did this, but now i've forgotten the formula. I want to comapre two lists, I want to use a conditional formatting, so that those cells that their contents doesn't exist in the other list would be marked in color gray. if anyone can help please! last time I remeber I used the function countif(). thanks a lot. Mansure |
#2
|
|||
|
|||
Hi
if your lists are in A1:A100 and B1:B100 try: - select A1:A100 - goto the conditional format dialog - enter the formula =COUNTIF($B$1:$B$100,A1)=0 - choose your format -- Regards Frank Kabel Frankfurt, Germany "mansure" schrieb im Newsbeitrag ... Hi once i did this, but now i've forgotten the formula. I want to comapre two lists, I want to use a conditional formatting, so that those cells that their contents doesn't exist in the other list would be marked in color gray. if anyone can help please! last time I remeber I used the function countif(). thanks a lot. Mansure |
#3
|
|||
|
|||
Thank you veeeeeeeeeeeeeery much Frank.
"Frank Kabel" wrote: Hi if your lists are in A1:A100 and B1:B100 try: - select A1:A100 - goto the conditional format dialog - enter the formula =COUNTIF($B$1:$B$100,A1)=0 - choose your format -- Regards Frank Kabel Frankfurt, Germany "mansure" schrieb im Newsbeitrag ... Hi once i did this, but now i've forgotten the formula. I want to comapre two lists, I want to use a conditional formatting, so that those cells that their contents doesn't exist in the other list would be marked in color gray. if anyone can help please! last time I remeber I used the function countif(). thanks a lot. Mansure |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Lists | Links and Linking in Excel | |||
HELP - Have two lists and #1 needs #2's contents subtracted from it | Links and Linking in Excel |