# Excel Project(repost)

This is an Excel project with the following requirements.

1-the values in certain first range of cells is to be rounded up or down to the nearest predefined fraction.

2-the new values is then compared to the values in second range of cells.

3-When the matched values are found then the cells in the second set should be formatted exactly like the matched cells in the first range of cells.

## Deliverables

This is an Excel project with the following requirements.

1-The values in a predefined range of cells (which we call the? Range A) is to be rounded up or down to the nearest predefined fraction (e.g .01 or .05 or .25 ).

2-The new rounded values is then compared to the values in another range of cells (which we call the? Range B? ).

3-When the matched values are found in Range B then the cells in the? Range B? should be formatted exactly like the matched cells in? Range A? (i.e. font size, font color , background color ,etc...).

Note: the ranges that are used may be from different worksheets but are all in the same workbook.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 2:01:37 PM:

Attention all biders: Please take note that since the code will be used many times on many ranges in a workbook , there must be a user friendly way for me to define 3 pieces of information. 1- The fraction by which the values in range A to be rounded up/down.(e.g. 0.10 or 0.25 or etc...) 2- Range A needs to be defined. 3- Range B needs to be defined. Please adjust your bids if you need to.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:11:12 PM:

Thank you all for your bids . It seems a little more clarification is needed. Below is an example of how the code should work. Suppose Range A contains 5 cells with values 100.23 , 153.435 ,413.02 , 254.78 , 367.89 This range is rounded to the nearest .25 decimal which gives the following values : 100.25 , 153.50 , 413.00 , 254.75 , 368.00 Range B has 1360 cells starting from 80.00 to 420.00 (with 0.25 increments apart like 80.00,80.25,80.50,..to...,[url removed, login to view],420.00) Now what the code does is to find the value of the cells in Range A that match the cells in Range B and will format the same cells in Range B as they are in Range A.(same font size , color , background, etc...) Note: There are going to be many sets of Range A and Range B in the same worksheet and workbook and each set should operate separate from each other.

* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:15:31 PM:

By the way please try to provide the most efficient and user friendly and least time consuming method as this will have the greatest impact of your bid being accepted (with a reasonable bid price of course).

* * *This broadcast message was sent to all bidders on Tuesday Jan 5, 2010 6:17:47 AM:

It seems there are a lot of unresolved issues for many bidders so in order to answer all your questions I have attached a new zip file which contains four files to provide full explanation . Please start with the file named “Project description?? and after studying all the files please adjust your bids and time required to do the task accordingly.

( 3 comentários ) los gatos, United States

ID do Projeto: #3059774

## 29 freelancers are bidding on average \$84 for this job

pShankar2

See private message.

\$85 USD in 14 dias
(408 Comentários)
7.1
shikhamehta

See private message.

\$157.25 USD in 14 dias
(232 Comentários)
7.0
schandraram

See private message.

\$85 USD in 14 dias
(169 Comentários)
6.9
LogixSmith

See private message.

\$17 USD in 14 dias
(55 Comentários)
6.0
expbingo

See private message.

\$21.25 USD in 14 dias
(27 Comentários)
5.0
Lotusdeveloper

See private message.

\$106.25 USD in 14 dias
(82 Comentários)
5.2
mdsoftsl

See private message.

\$153 USD in 14 dias
(12 Comentários)
5.0
excelsolution

See private message.

\$59.5 USD in 14 dias
(66 Comentários)
4.8
tatasthuinfotech

See private message.

\$25.5 USD in 14 dias
(13 Comentários)
3.3
kanhashriinc

See private message.

\$29.75 USD in 14 dias
(9 Comentários)
2.9
nguyenhoangtran

See private message.

\$17 USD in 14 dias
(3 Comentários)
2.2
satheez1984

See private message.

\$6.8 USD in 14 dias
(2 Comentários)
2.3
tookool4uvw

See private message.

\$45 USD in 14 dias
(5 Comentários)
2.4
lalchetian

See private message.

\$42.5 USD in 14 dias
(2 Comentários)
2.0
silverlinesoftvw

See private message.

\$11.05 USD in 14 dias
(7 Comentários)
1.8
PeopleWorld

See private message.

\$25.5 USD in 14 dias
(2 Comentários)
0.8
isoli

See private message.

\$17 USD in 14 dias
(1 Comentário)
0.5
pearlveera1

See private message.

\$42.5 USD in 14 dias
(0 Comentários)
0.0
AcesProject

See private message.

\$110.5 USD in 14 dias
(0 Comentários)
0.0