I have a google docs spreadsheet that requires 2 separate scripts to be written.
(1) The first script requires a little more power than what the conditional formatting function allows. I need conditional formatting based on a calculation of two other cells value. For example, (all data in all cells is manually input) cell J4 has the following options for data "In" "any numeral". If cell J4 reads "In" I want the background of the cell to be white. If value of J4 is equal to H4-I4, for example H4 is "10" and I4 is "8", and J4 is "2" then I want the background of the cell to be green. If value of J4 is not equal to H4-I4, for example H4 is "10, I4 is"8" and J4 is "4" then I want the background of the cell to be red.
(2) The second script needs to automatically input a set of values into a cells dependent on multiple tests of different cells in another sheet. For example, the value of cell B4 in sheet "Greensheet" will depend on the following conditions:
In sheet "Greensheet" there are several pieces of data input. cell B1 is an employee's name "Sean". Cell A4 is date "7/29/2012". The value for cell B4 needs to look at the value of another sheet "Payroll" match the employee's name from sheet "Greensheet" cell B1 to the employee's name in sheet "Payroll" which will be anywhere in column D. After a match by name has been made, a match by date needs to be made. The date in sheet "greensheet" Cell A4 must match with the date, for the correct employee, in sheet "payroll" column A which will have a list of dates. After the match of employee and date has been made, then the value in sheet "payroll" that corresponds to that employee and date must be input into sheet "greensheet" value for B4.
This task of filling in values for sheet "greensheet" needs to be accomplished across 4 different values. This script needs to be applied to multiple sheets that will have different employee names and different ranges of dates.
The budget for this project is $100. Please submit your best price bid along with your level of expertise in google docs script writing. If you have any similar projects you have worked on please let me see some examples of your work.
You will be given access to the spreadsheet via google docs. We will work together on accomplishing the job and I am available to answer or clarify any details. Payment will be given upon completion and receipt of the scripts that will accomplish the task. Thank you for your attention.