Closed

Excel function

This project was awarded to agihcam for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
7
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online