Sedang Disiapkan

Excel function

Hi there,

1.

I need that the style of a list cell changes automatically when an item is being selected from the list itself.

The list cell must inherit the style of the cell from which it gets the data from, background color, font color, border style...

The list gets the data from an other sheet using the VLOOKUP function.

Suppose to have a list of articles in the "Sheet 1".

On the "Sheet 2" you have the articles status descriptions, for example "New Item", "New Color", "New Style"...

To each status is related a specific style, for example the "New Item" status is on a pink cell and the font color is white, the "New Style" status is on a green cell and the font color is black and so on.

These status are shown in the list on the "Sheet 1".

So if you select the "New Item" status from the list on the "Sheet 1", the cell list style should change according to the article status style on the "Sheet 2".

Since the list is composed by more then 3 items, the conditional formatting is excluded.

If a macro is needed to solved all above is fine, but if it could be solved with normal functions it should be better.

Of course if I add any new statuses I need that the system still working.

File attached as reference.

-----------

2.

I need to insert automatically pictures in a worksheet.

The pictures are located in a specific folder, they have different size and resolution.

So I need Excel to resizes them keeping the aspect ratio, manages the images quality and set the resolution to 72dpi for each file.

Here are a step by step procedure I would like to apply if possible:

1. I set up the cell size that has to host the picture.

2. I write down the file/s path/s in the cell, for example: images/MyHolidays/[url removed, login to view]

3. Then I run a macro (at least I guess) and Excel look for the file/s in the folder.

If the file exists Excel analyzes it, resizes it according to the cell size and it manages the quality as well.

I need to manage the images quality to save some weight, so I can send easily the worksheet by email.

------------

I need someone that could do all above in a really short time.

Thanks.

Kemahiran: Excel

Lihat lebih lanjut: excel function list, inherit style excel, excel function font style, excel function style, excel function pictures, function color font excel, excel color function, excel function creator, excel inherit style, excel equation maker, new excel, n excel, send email excel, save excel, run sheet, pink, macro excel, images excel, hi resolution, function, excel vlookup, excel function, excel formatting, do excel, size function

Tentang Majikan:
( 6 ulasan ) Mantova, Italy

ID Projek: #349182