Excel Project

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 first range) 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 second range ). 3-When the matched values are found then the cells in the second range should be formatted exactly like the matched cells in the first range (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...,[login to view URL],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).