Forum Discussion
Conditional formatting using a vlookup formula
Hi there, This is my first post for asking for help. I have a spreadsheet that we use to record our outbound mail information, so it doesn't process any numbers or anything, it's merely just a reco...
Hello,
it's a bit hard to visualize what you want to achieve. Can you attach a simplified example with non-confidential data? Just a few rows will be enough. Then explain the desired outcome and the logic that leads to it.
Hi there,
I've attached a really brief example with just one month/worksheet and a sheet for the 'client docs to be returned'.
In the monthly worksheets, i'd like any surname that matches with a surname in the 'docs to be returned' worksheet to be highlighted, so we know to grab them and post out.
thank you
Rebecca
Two or three more rows of data would be great, so I understand what you are trying to achieve. Also a sheet for Feb and Mar and some data that pertains to these sheets. Does the Date in the January sheet need to be matched with the date in the "clients original" sheet? I don't quite see the full extent of the connection and what rules lead to the highlight.
Hi there,
Thanks so much for your response so far to help me. I've updated the sheet a bit.
- the dates don't need to match, it's just for our records so we know when client info has come in
- the surname details in the client docs to return sheet and the current months sheet is what we're looking to highlight. So when we're recording, say, today's outbound mail details, and Walker is typed in, if there is a 'Walker' surname in the 'client original docs' sheet, i'd like the name to be highlighted in the current months worksheet so I send out their docs with the letter.
Does this help? I haven't explained very well.
thank you
Rebecca