MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I have 2 worksheets, one is a list of towns that accepted an invitation, the other is a list of all towns invited and what county they are in. The first sheet uses a vlookup to add the county to a column next to the town name.
I would like the 2nd sheet to record ( by highlighting or fillling in the town name) the na,es of town who gave accepted invites so that we can quickly see who to follow, I'm thinking conditional formatting by formula but can fight out the formula.
I find a good solution often needs a clear requirement, and I'm not sure that this is clear.
I think you are over complicating, surely for the formula to work then you will need to amend / add data, therefore you are likely to be just as quick in the long run by manual filling the cell with a colour.
oh and it's "of town which"
why two worksheets? you seem to be overcomplicating the problem. KISS
Also can't see what you trying to do, why can't you just use the list of accepted invitations?
Don't have excel in front of me but presumably you can format vlookup to give a boolean value for the conditional format. As others have said it seems a bit backward.
You no what, you're right, i am making it over complicated.
Sheet A is populated by someone cut/pasting the responses into it, there's about 14 columns with various details,but lacking the County.
Sheet B is a full list of towns/ counties.
Sheet A uses a vlookup to sheet B to insert the County next to the town.
As Sheet b is the full list, I would like this list to highlight the towns that have responded.
Sheet B could use vlookup and an if statemment to give 1 or 0 in a new column and then conditional format the town cells based on that
=IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,FALSE)),"No Invite","Invite")
Assuming A:A is your list of towns on each sheet.