176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Color Code+ : Google App Script
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 4, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Feb 01, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I am wondering if you can help. I trying to quickly at glace visionally see if the value in one column are higher or lower from the proceeding column. Which I have managed to do with your Color Code+ using your code slightly adapted :

/***
* Color Code+
* Conditional formatting with cell referencing for Google Spreadsheets
* Support: bryanp.com/color-code-plus
**/

function onEdit() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = ss.getActiveSheet();
var values1Rule1 = s.getRange('d2:d').getValues();
var values2Rule1 = s.getRange('c2:c').getValues();
var range3Rule1 = s.getRange('d2:d');
var color1 = 'Green';

for (var row in values1Rule1) {
for (var col in values1Rule1[row]) {
if (values1Rule1[row][col] > values2Rule1[row][col]) s.getRange(s.getRange('d2').offset(row, col, 1, 1).getA1Notation()).setFontColor(color1);
else s.getRange(s.getRange('d2').offset(row, col, 1, 1).getA1Notation()).setFontColor('Red'); }}

};

As you can see from the attached screen shot i...

Sign in or Register to see more

Job ID: 37414686
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
I am listed as Google Apps Script Top Contributor on Google Apps Script support page. (https://developers.google.com/apps-script/support) I have...
3
  |  
 0.0   |  Private   |  2 Jobs
Bid ID: 37501196  |  Submitted: Feb 4, 2013 08:37 ET 
Proposal SEALED

 United States  |  
Winner
Offering to glue together any Google Apps products you use with Google Apps Script. Specializing in workflow automation within Google Spreadsheets.
5
  |  
 4.0   |  Private   |  20 Jobs
Bid ID: 37422626  |  Submitted: Feb 1, 2013 09:49 ET 
Delivery
Within 3 days
$20.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »