I use the 'LOOKUP' function in Excel in dozens of different spreadsheets.

It's no understatement to say that I live by it for sport, business and even leisure.

What would be really useful would be if the format (particularly background colour, type size etc.) could be imported too. Is this possible, or is it just asking too much?

I'm generally using 2007 or 2013 versions.

socram - 2021-07-14 22:06:00

you could have a look at the conditional formatting options
https://how2foru.com/excel-how-to-change-the-background-colo
r-based-on-the-cell-value_268/
https://www.ablebits.com/office-addins-blog/2013/10/18/chang
e-background-color-excel-based-on-cell-value/

otherwise Macros are required
https://excelribbon.tips.net/T013236_Changing_Font_Face_and_
Size_Conditionally

Edited by king1 at 11:11 pm, Wed 14 Jul

king1 - 2021-07-14 23:07:00

Thanks, but not quite what I needed.

socram - 2021-07-15 12:54:00

I don't think you can do so without resorting to VBA and my general rule of thumb is if it requires VBA to do in Excel then Excel is the wrong tool for the job.

vtecintegra - 2021-07-15 12:57:00

vtecintegra wrote:

I don't think you can do so without resorting to VBA and my general rule of thumb is if it requires VBA to do in Excel then Excel is the wrong tool for the job.

I agree. There is a use for a lookup in Excel to do a simple job and I have done lots of VBA for Excel when it is not so simple but in general I would use a database

duncb - 2021-07-18 23:59:00