|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » Excel Gurus » Post Reply
|
pow |
posted on 23rd Jan 13 at 10:06 |
My solution works Ian, I tested it :( :lol: | |
Ian |
posted on 23rd Jan 13 at 09:56 |
So you want each cell in the A column to be compared to the whole of column C? | |
pow |
posted on 23rd Jan 13 at 09:53 |
quote: From what I understand A2, A3, A4 etc must compare to C2:C200 - hence the $'s when you drag the formula down | |
Ian |
posted on 23rd Jan 13 at 09:52 |
Do you want one single cell to compare to the column? | |
pow |
posted on 23rd Jan 13 at 09:49 |
=IF(COUNTIF($C$2:$C$200,A2),"True","False") | |
pow |
posted on 23rd Jan 13 at 09:42 |
I see, stick this in D2 and drag it down (hide it if you don't want to see it): | |
Bart |
posted on 23rd Jan 13 at 09:31 |
any ideas? | |
pow |
posted on 23rd Jan 13 at 09:31 |
Conditional formatting is the one here, it'll do it no problem | |
Ian |
posted on 23rd Jan 13 at 09:20 |
Condition formatting and there should be something in there that you can use as your match condition. | |
Bart |
posted on 23rd Jan 13 at 09:19 |
Im after some help with a formula. |