VLOOKUP and Conditional Formatting

[Guest]

I have a w/s that populates data from other w/s's using VLOOKUP, based on selections from a dropdown. If you select "loan balance", it picks up loan balances, if you select "deposit balance" it displays deposit balances, etc. I want to add other values to the dropdown and diplay on the w/s such as delinquency rates, risk ratings, etc. but they obviously have different data formats (percentages, decimals). I believe I can use conditional formatting to achieve this, but can anyone provide a couple of actual examples? Currently I put the different data types on seperate w/s's but I have been asked to combine them into one. Thanks in advance for you assistance

 

[RagDyer]

I don't believe Conditional Formatting will be able to provide what you're
looking for.

Try placing your lookup formulas in different columns, and format each
column to accommodate the data that will be returned.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a w/s that populates data from other w/s's using VLOOKUP, based on
selections from a dropdown. If you select "loan balance", it picks up loan
balances, if you select "deposit balance" it displays deposit balances, etc.
I want to add other values to the dropdown and diplay on the w/s such as
delinquency rates, risk ratings, etc. but they obviously have different data
formats (percentages, decimals). I believe I can use conditional formatting
to achieve this, but can anyone provide a couple of actual examples?
Currently I put the different data types on seperate w/s's but I have been
asked to combine them into one. Thanks in advance for you assistance

 

[Frank Kabel]

Hi
this could only be done with VBA 8using an event macro). If you could
provide some more details an example procedure is easy to set-up. You
may also have a look at
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

I have a w/s that populates data from other w/s's using VLOOKUP,

based on selections from a dropdown. If you select "loan balance", it
picks up loan balances, if you select "deposit balance" it displays
deposit balances, etc. I want to add other values to the dropdown and
diplay on the w/s such as delinquency rates, risk ratings, etc. but
they obviously have different data formats (percentages, decimals). I
believe I can use conditional formatting to achieve this, but can
anyone provide a couple of actual examples? Currently I put the
different data types on seperate w/s's but I have been asked to combine
them into one. Thanks in advance for you assistance

 

[Guest]

Thanks for responding. I'll try to concisely provide more details: I have a w/s that displays financial data for the last 12 months to show trends. There is a dropdown box for users to select the specific line item from teh Income Statement or Balance sheet they want to report on. The VLOOKUP formula gets the financial data from other w/s's where the actual data is stored (this data is imported from other sources). Currently the users can only select financial data so the cell formats are set to 'currency". I want to add qualitative data such as "percentage of loans delinquent", average risk rating of loans, headcounts, etc which are stored on another w/s. I would add these choices to the dropdown box fr the user to select. currentl they are selected from another w/s that has the cells formatted as numbers. I hope this is enough detail. I could send an actual workbook if that would help, but it is about 10MB in size.

Thanks again for your assistance.

 

[AlfD]

Hi!

Maybe give each lookup its own worksheet which you could prettify a
well as format? Simple macro to take you to a named sheet.

Al