jondallimore
Board Regular
- Joined
- Apr 26, 2012
- Messages
- 136
Hello,
I'm after a formula which would check that all the names on a list in column A are included in a range of data from B1:Z100 (might be different, but I can change it).
THe formula needs to return a "DONE" or "NOT DONE" - something like that.
Also, a red cell whilst its Not Done, and a Green when it is done would be useful - I would imagine conditional formatting would be the only way to do that?
This may be really simple, but I'm tired and my head is squishy from bashing it against excel all day...
Any help greatly appreciated.
I'm after a formula which would check that all the names on a list in column A are included in a range of data from B1:Z100 (might be different, but I can change it).
THe formula needs to return a "DONE" or "NOT DONE" - something like that.
Also, a red cell whilst its Not Done, and a Green when it is done would be useful - I would imagine conditional formatting would be the only way to do that?
This may be really simple, but I'm tired and my head is squishy from bashing it against excel all day...
Any help greatly appreciated.